Accounts Receivable and Payables Balance Sheet discrepancy

  • 2
  • Problem
  • Updated 5 years ago
  • In Progress
  • (Edited)
When I look at my Chart of Account list I can see my Accounts Receivable and Accounts Payable balances BUT in my Company Balance sheet those figures do not carry over. I have an odd NEGATIVE figure in Accounts Receivable and Accounts Payable (Trade Creditors) doesn't appear at all? Any suggestions? I have 2 company accounts and they both do the same thing...
Photo of Femie Manderhuon

Femie Manderhuon

  • 100 Points 100 badge 2x thumb

Posted 6 years ago

  • 2
Photo of Graham Meredith

Graham Meredith, Accredited Partner

  • 280 Points 250 badge 2x thumb

Hi Femie

It sounds like you have been writing journal entries to the general ledger account for these two accounts which would indicate why the two accounts do not agree to your balance sheet.

Create a Balance Sheet report, then double click on your Accounts Receivable Balance. Click on Modify in the top left and once there, click on Filters. Find the item in the box called Transaction Type and click on Journal from this group.

Than click OK and change the date range item to "All"

That will show you all of the journal entries that have been made which should be the difference between your Accounts receivable ledger and your balance sheet amount.

Photo of Femie Manderhuon

Femie Manderhuon

  • 100 Points 100 badge 2x thumb
No there are no journal entries posted. To be certain I have followed the instructions above as well it is a null report. Any other ideas?
Photo of Graham Meredith

Graham Meredith, Accredited Partner

  • 280 Points 250 badge 2x thumb

Hi Femie

Just to confirm are you only using one Accounts receivable and one Accounts payable account in the Chart of Accounts.

If you look in the Chart of Accounts are their "Type" Accounts receivable and Accounts payable respectively ?

Photo of John G

John G, Information Support Analyst

  • 27,510 Points 20k badge 2x thumb
Hi Femie,

Has your balance sheet discrepancy now been resolved?

regards,
John
Photo of Femie Manderhuon

Femie Manderhuon

  • 100 Points 100 badge 2x thumb
I have been out of office back tomorrow so will check last fix and respond tomorrow. Thankyou
Photo of SusanR

SusanR, Accredited Partner

  • 1,938 Points 1k badge 2x thumb
Hi Fernie, 

In addition to Graham's post, you could check whether you are running the Balance Sheet from a previously memorised report and the Balance Sheet report settings are set to Cash. 

You could also check your overall report preferences from the drop down menu Edit > Preferences > Reports & Graphs > Company Preferences.  These settings are separate and can be different to your GST reporting basis settings which can be found from the drop down menu Edit > Preferences > Tax > Company Preferences.

Kind Regards, Sue
Photo of Fahad

Fahad

  • 60 Points
Hi guys,

I have same issue as Femie has mention in this thread. My Accounts Receivable chart of accounts says I have balance which has large discrepancy when I check in balancesheet. I have tried everything mentioned above by everyone. But still the problem is not resolved. I am currently using reckon hosted 2014.
Photo of Kathy Mackinlay

Kathy Mackinlay

  • 3,150 Points 3k badge 2x thumb
Hi all,

I have the same issue. When i run the Balance Sheet the total for Accounts Receivable and Payable are different from the report off the Customers and Suppliers. I have isolated which customers and suppliers they are but cannot work our how the difference has been got. The customers statement is correct balance but the b alance on the A/R summary report is not.
Photo of Graham Boast

Graham Boast, Accredited Partner

  • 11,654 Points 10k badge 2x thumb
Hi.

A few reasons that this can be different:

Check Edit > Preferences > Reports & Graphs > Company Preferences.  The Default Reporting settings should be set to ACCRUAL and NET irrespective of whether you are Cash or Accrual GST.

This will more than likely be the issue.

If not, double click on the account from the Chart of Accounts and look to see if there are any transactions dated in the future.  If you are running a balance sheet dated today, this will differ the Chart of Accounts which will show the last balance, even if in the future.

If the default preferences are set to accrual & net, the A/R Ageing Summary (or A/P Ageing Summary), the trial balance and the balance sheet should all agree.

Graham Boast
Reckon Accredited Consultant
graham@reckonhelp.com.au
www.reckonhelp.com.au/remotesupport.htm
Photo of Kathy Mackinlay

Kathy Mackinlay

  • 3,150 Points 3k badge 2x thumb
Hi Graham,

I have checked all my parameters. i have identified the Customer who has the incorrect balance on the Accounts receivable report. I can't work out how the balance can be different on the A/R detail report and the customer enquiry screen? I need these to balance for the Accountant to do the end of year.

This conversation is no longer open for comments or replies.