Forum Discussion

SungbyJess's avatar
2 months ago

Reconciled bank account is not reflected in the Balance sheet report.

I have reconciled my bank account and it matches the running bank balance.  This is at the end of the financial year.   When I make a report Balance Sheet for the end of the financial year, the bank account does not equal the amount I had reconciled it with at the same date.....
I am a novice at this, but I thought that once I have reconciled the account, this would also be reflected in the balance sheet as long as the dates are the same??

 

There are lines in the reconcile page that are not "selected", and this is what the account defaults to.  Are these "unselected/included" lines still incorporated in the Balance Sheet reports??

(I don't know why these lines are not included)

 

I have attached a screenshot of the Reconcile page as of 30/06/2024, and also the Balance sheet as of 30/06/2024.  It is the balance in parentheses that I am interested in - should it not equal the reconciled value of $8.58, and not -ve ($13,588)?

5 Replies

  • There could be a few reasons for this discrepancy
    1. Recommend clearing the outstanding transactions in your bank reconciliation prior to 30/6/24
    2. Check your bank feeds (if you have bank feed setup) to ensure all bank feeds are allocated
    3. Check for any bank feed from 1/7/24 that have been allocated but the transaction is dated prior to 30/6/24

  • Thanks Chris,

    There are no un-allocated transactions - is that the same as your outstanding transactions you mentioned above?

    From the reconcile page, there are a number of un-selected transaction lines.  I have not changed that from the opening page. The reconciled bank balance matches at that point.  If I do select ALL the transactions, then the "calculated closing balance" does match the -$13,588 that mentioned is the number reported on the Balance Sheet for that period.   I would have thought the un-selected transactions would be also excluded from the Balance Sheet ?  Do I need to delete them?

     

  • Thanks for your reply
    Yes you need to clean up these outstanding transactions on the bank reconciliation and try and match to the bank feed/s
    As for incorrect closing balance, if you run a balance sheet at 31/12/24 (assuming you have assigned transactions to end of December, do you have the same incorrect balance at 31/12/24?

  • I have 'cleaned up' those transactions and the balance is now correct - thanks.  So this means that these were duplicate transactions?  Did I not 'match' them correctly when the bank feeds are incoming?