differences bet A/P report and BS at period end ??

  • 1
  • Question
  • Updated 5 years ago
  • Answered
I have a significant difference i between the A/P report and the A/P on the B/S. If I drill down into the transaction on the Payables report they have mostly been paid since 30.06. However, the B/S shows only unpaid amounts as at 30.06, not any 'current' bills that would have been payables at the end of the year???? 
Photo of Sandra Lindstrom

Sandra Lindstrom

  • 70 Points

Posted 5 years ago

  • 1
Photo of vinia

vinia, Employee

  • 1,114 Points 1k badge 2x thumb

Hello Sandra,

Thank you for using the Reckon Community.

About the query you have entered, you may need to follow the steps below to check why this is happening. If this does not resolved the issue its best to contact our support team to discuss the issue in much further explanation.

Question:

Why don’t the totals in the Ageing Summary Reports for Accounts Receivable and Accounts Payable match the balances in the Balance Sheet?

Solution:

There are a number of reasons this difference may happen:

1.    Balance Sheet is reporting on a Cash Basis; Ageing Summary Reports always report on an Accrual Basis;

2.    Date ranges are different.

Care: All Dates setting will show transactions that are dated forward of the current date;

3.    Corruption in the company file.

Solutions

Set the Balance Sheet to report on an Accrual basis:

1.    Open the Balance Sheet Report;

2.    Modify > Report Basis > Accrual > OK

Check that the date range is the same on both reports.

If there are transactions for a future date, examine the transaction for accuracy

Rebuild and Verify the company file:

1.    File > Utilities > Rebuild

2.    File > Utilities > Verify

3.    If an error is found, examine the QBwin.log file:

a.    Ctrl+1 > Ctrl+2 > Open File > double click on QBwin.log

b.    Scroll to the bottom of the file

c.    Examine errors and make necessary corrections. 

4.    File > Utilities > Verify to confirm that no errors remain in the file. 


if there is anything else I can help you with let me know.

Kind Regards,

Vinia