cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
ilearncent
Level 1

My bank amount and posted amount is out by a huge amount.Also noticed if i sort chart of accounts from old to new it gives me different result apposed to new to old

My bank amount and posted amount is out by a huge amount.Also noticed if i sort chart of accounts from old to new it gives me different result apposed to new to old

1 Comment 1
Kurt_M
Moderator

My bank amount and posted amount is out by a huge amount.Also noticed if i sort chart of accounts from old to new it gives me different result apposed to new to old

The QuickBooks Balance reflects all transactions posted to your financial books, while the Bank Balance is the actual real-world cleared amount pulled from your bank feed. Discrepancies between the two usually stem from unaccepted transactions, incorrect register sorting, or duplicate entries.

To resolve this, go to your Chart of Accounts, open the account register, and click the Date column header until the arrow points down or Newest to Oldest. This fixes the running math calculation and displays the current QuickBooks Balance on the top row.

Next, accept or match all transactions in the bank feed's For Review tab. Finally, sort your register by the Payment or Deposit columns to quickly locate and delete any duplicate entries caused by accidentally adding instead of matching transactions.

If you have other questions about QuickBooks, please don't hesitate to click the Reply button.