CUSTOMER OPEN BALANCE PROBLEM

  • 1
  • Question
  • Updated 3 months ago
  • Answered

the opening balance invoice which reckon produces automatically isn't allocated an item just states 'open balance" in description and it shows up under accounts receivable in chart of accounts instead of in Open Balance Equity. (using Hosted 2018) Is this correct or am I doing something wrong?


Photo of Vanessa

Vanessa

  • 292 Points 250 badge 2x thumb

Posted 3 months ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 15,144 Points 10k badge 2x thumb
Hi Vanessa - thats how its intended to work if you are setting up a new file and bringing across balances from another system or period?  - When you also enter a journal for the balances in the Balance Sheet - the value of the total Accounts Receivable should be entered to Open Balance Equity and this should then zero out the amounts that went in with the Opening balance invoices... so if its all been done correctly with Customers and Suppliers - the Open Balance Equity should be zero and each individual Customer and Supplier should have a balance which shows when you run the AR Ageing and AP Ageing reports and shows in Accounts Receivable and Accounts Payable in the balance sheet.  Take care that you use the correct dates on all transactions - this is very important for getting good reports.  eg if moving from one system to another for the new financial year - the Bal Sheet figures from the old system should be entered as the 30th June.. and all the Opening Balances for Customers and Suppliers should either be 30th June or whichever date is correct in terms of Ageing of the outstanding amount.  
Photo of Vanessa

Vanessa

  • 292 Points 250 badge 2x thumb
Thank you so much Linda, makes perfect sense on both questions. Really appreciate it.