Bank Reconciliation Out of Balance

There are many reasons you could have a bank reconciliation error – a few common reasons are as follows:

- Receipts entered for the incorrect amount
- Receipts entered more than once
- Payments being made at the bank but not yet made in Palace
- Eftpos receipts taken over the counter but not entered or presented in Palace
- Reversals being done, but not re-entered
- Bulk payments being processed and bank account numbers missing in Palace so the payment
is excluded from the bank online file


First, you need to determine what type of error you have:


A positive error, generally means that there is more in Palace than in the bank
A negative error, generally means that there is more money in the bank than in Palace
A common mistake that is made when dealing with a bank reconciliation error is fixating on the
amount you are out by. For example, an error of -$400, could be
- A receipt for $400 that has not been entered
- Or it could be multiple receipts ($150 and $250 etc)
- Or it could be a receipt AND a payment (ie, receipt of $600 and a payment for $200)

Run through the appropriate checklist below:


A positive error
- Check the closing balance is correct
- Check if there are any debits on the bank statement that you need to present if they are not
in the unpresented list, check if they have in fact been made in Palace
- Check that you have not presented a receipt that isn’t a credit on the bank statement
(ie, Eftpos or Cash)
o In the Bank Reconciliation, go to the Presented Tab
o Find the date you are troubleshooting for, use the blue arrow to expand and see all
transactions that were presented for that date

- Check all the receipts that have been entered to make sure there are no duplicates or
incorrect amounts, you can print a receipts report and compare the receipts entered against
your bank statement
o Financial > Audit Reports > Audit Trans (Receipts)
o Filter by date and use the date range from the last time you successfully balanced your bank rec
to today
o Generate – tick off each receipt based on the receipt seen on the bank statement

A negative error
- Check the closing balance is correct
- Check if there are any receipts in the unpresented list that need to be presented (ie, Eftpos
or cash that has cleared in the bank and was already entered into Palace but not presented
yet)
- Check that you have not presented a payment or refund that isn’t a debit on the bank
statement
o In the Bank Reconciliation, go to the Presented Tab
o Find the date you are troubleshooting for, use the blue arrow to expand and see all
transactions that were presented for that date

- Check the payments that have been entered to make sure there are none missing or
processed for incorrect amounts, you can print a receipts report and compare the receipts
entered against your bank statement
o Financial > Audit Reports > Audit Trans (Payments)
o Filter by date and use the date range from the last time you successfully balanced your bank rec
to today
o Generate – tick off each payment based on the debit seen on the bank statement
o For bulk payments that were made, check the Direct Credit Schedule that was saved,
the total of this should match the total payment on the bank statement. You can
then check the direct credit schedule breakdown against the payment report to see
if there was a payment missing from the schedule (due to an account number
missing)

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.