Bank account reconciliation

Another user somehow posted transactions, we are not sure how or through which module, showing debit bank/credit prepaid expenses; then made a reversing entry, then another reversing entry resulting in 2 credits and 1 debit to the bank account (all for the same amount). These three transactions show in the reconciliation module/screen, but when we try to find the general journal entry, or find them through the bank account or prepaid expenses account they do not show up at all. We have searched by amount, journal number, date etc. and on viewing the accounts, there are no transactions of that amount showing. We can clear 2 of them (one debit and one credit) without affecting the actual bank account balance, but that leaves the second credit entry outstanding with 0.00 unresolved. We would like to delete this one, or even better all three, but we are just unable to locate the transactions outside of the reconciliation screen. Does anybody have any advice - how can a transaction show in the reconciliation screen but not actually show in the chequing bank account in Sage? How would we locate these transactions in order to delete/void them? 

  • There are several possible issues going on here.  One is that the account is linked in the sales module and was used for a prepaid customer Sales Order.

    If the account is not linked, then the original and reversing entry may not show in the General Ledger report because you have corrections turned off.  Turn them on and you may see them.  However, that doesn't account for why the final entry is not showing.  Usually when that happens, the issue is that the report is being run on a date range that does not include the entry you are looking for.

    One way to track it down is to double-click the dollar amount in the Bank Rec module.  This will open the Journal Entry report showing the entry.  Then you can double-click the Source or Comment to get further information.  You can also use the journal entry number on that report to run all journal entries or the General Ledger report to try and find the entry (but remember to show the Corrections).

  • 0

    in this box top right corner type in amount it will show all transactions for the amount you are looking for AR or AP sides it will also show je and adjustments