Browse By Tags

  • Item Valuation Report vs Count Sheet value

    Hi, I'm preparing for our annual inventory counts and having a valuation issue. When I run the Item Valuation report as of March 31st for a range of account sets and locations it gives me a total for each location. But when I generate the inventory…

  • 1st credit card rec

    I am still waiting for an answer to my question 10 days ago. I started my 1st credit card rec. I entered all transactions from the statement and checked them off. Opening balance and ending balance from the statement. (GOOD) I am good with all postings…

  • Bank Reconciliation help needed.

    Hello there , i started reconciliation and even there is no withdrawal cleared but the totals screen shows clearing of $ 1000. where should i look to figure this out?

  • Bank Reconciliation - SLOW

    Our bank reconciliation is so slow - system takes forever to calculate. What data do we need to purge to make this process faster? Do we need to clear history?

  • year end bank reconciliation - bank statement date is Dec 29th not 31st

    My 2023 Dec actual RBC bank statement ends Dec 29th My fiscal year ends Dec 31 2023 there is no banking transactions in my online banking for Dec 30 or 31th. I have not yet received the Jan 2024 statement, obviously bc the month is not complete…

  • bank reconciliation

    Hi Could you kindly assist me with an issue I encountered in Sage300? How Can I reduce “Withdrawals Outstanding” amount on bank Reconcile Statement without affecting in GL accounts?

  • Sage 300 Month End Procedures

    Does anyone have a month-end procedure that they follow in Sage 300? Reconciling accounts payable to the balance sheet, etc? I'm looking for something to have everyone follow to ensure that everything is entered correctly.

  • How put negative sign in Gst purchases in balance sheet

    Hi there! I have a problem with our sage 50. I am currently a bookkeeper and I having a problem with GSt purchases in balance sheet. It doesnt show the negative sign, and it's adding the gst sale and gst purchase. The previous bookkeper up the books as…

  • upload bank statement

    Hello - Can I convert my bank statement from pdf format to the .ofx for sage upload? I can't seem to find the option when downloading from my bank.

  • Bank Reconciliations

    My bank reconciliation is out, can I go back and re-reconcile an account? Also, we have EFT payments that get removed from the bank at the end of one month, but don't come out of our account until the early days of the next month on Sage. This is due…

  • Changing Cost Code After Invoice Has Been Paid

    Can you change the cost code of an invoice that has already been paid? Thanks.

  • How do I Undo a recent reconciliation so I can rectify something?

    When working with Quickbooks, we have a really easy way to undo a reconciliation to then adjust one transaction and re-save the reconciliation. How do I do that in Sage 100 Contractor?

  • Incoming Bank Transactions : transaction appears twice on VISA statement (2 currencies)

    Hello, In the Incoming Bank Transactions screen for my Credit Card, I see 2 separate entries for the SAME purchase : One entry is in CAD (41.18) and the other is in USD (29.99), as shown in the attached screenshot. Since I work in Canada, I processed…

  • Purchases Clearing Report <> balance with PO clearing GL account

    Specifically asking when you have a PV source journal due to Sage's KB scenario below, what are users best practice recommendations on how they handle the balance sitting in the GL PO clearing account? Do you leave the costs there, reclass somewhere,…

  • Sage 300 Posting Bank Reconciliation without asking all users to logout

    Multiple bank accounts that need to be reconciled and posted are being used by our Sage300 company. The problem is that, even when a certain bank isn't being used, it's always necessary to request that users log out. Is there another way to post a bank…

  • Paying invoice that has inventory

    Newbie here. When I go to make an invoice paid that has associated inventory items on the purchase it won't let me change payment to cash so my Bank reconciliation is off by these invoices. So the invoice stays as Pay Later. How do I make these payments…

  • Reconciling Shipment Clearing & Payable Clearing Accounts

    Hi, I want to know, what is the best way to reconcile shipment clearing account and payable clearing account ? is there an easy way to make it zero at the end of the reporting date. Thank you

  • Adjusted book balance not matching statement

    I have reconciled my bank accounts and the correct totals are showing with a zero adjustment required in the reconciliation window. Since this is back work (2022) I am working forward and the balance sheet at Jan 1 2022 is not showing the correct statement…

  • CM Old Uncleared Transactions cannot be reconciled or changed

    We are trying to clear up some accounts that were never properly reconciled. There are several transactions from past years that we need to mark as reconciled. When we attempt to change them in the Edit Register, we get an error that says: Could not…
  • Mismatch between I/C quantity and Lot/Serial quantity of an item

    Mismatch between I/C quantity and Lot/Serial quantity of an item

    How to fix mismatch between I/C quantity and Lot/Serial quantity of an item if there is a variance on the I/C Serial/Lot Number Quantity on Hand Report? Below is an example in our sample data for this item, A1-405/0 at location 1. As you can see the…

  • Bank Reconciliation Out of Balance

    I reconciled on 4/30/18 and all was good. Then i realized a bank transfer was entered twice, so i entered a transaction going the opposite way to clear one of them out. When i reconcile the statement for 5/3 and select both of the transactions it shows…

*Community Hub is the new name for Sage City