Skip to main content
August 23, 2024
Question

Matching Banking Transactions

  • August 23, 2024
  • 1 reply
  • 0 views

Need urgent help. I was matching gocardless or direct debit transactions in the for review tab as "add" as the client balance was automatically becoming 0. Now I discovered that this is double counting the revenue as the invoice as well as the bank deposit both are appearing there. Then I spoke to my accountant he explained that gocardless transactions most of the time do not match automatically. They come for review only when there is an issue. He asked me to undo what I did previously, then delete the payment from the invoice for each client manually and then "match" the transaction in review tab manually to each client again. When I tried this, I am unable to delete the payment in the invoice as the enclosed issue arises. It shows a bank deposit already exists and you need to delete that first before deleting the payment in the invoice. I zeroed out the bank deposit, then deleted the payment and rematched the transaction. It worked. However, now I am afraid that this will impact the back recon. Please help confirm if this will be ok. The bank recon is done by an external accountant so not sure how this will impact. I need to resolve all the transactions today so wanted a confirmation if this is fine. When I check the bank account in the balance sheet, it is showing the new transaction as well as the old one (old one with 0 value). But wanted someone to advice me if I should go ahead or is there a different way. [screenshot removed by a moderator]

1 reply

August 23, 2024

Thank you for sharing detailed information regarding your banking concern, shahreshma1611. I'll guide you to the right support that can help you keep your financial records accurate and your bank reconciliation organized.

 

Zeroing out bank deposits and rematching transactions will not cause issues if carried out correctly. Since your external accountant handles the reconciliation, I recommend contacting them for further guidance. They can give you specific advice to help you with your accounting tasks and make sure they align with their processes.

 

Furthermore, categorise your downloaded entries to the correct account and match them to the ones in QuickBooks Online (QBO) to keep your records organized. This will also facilitate a smooth reconciliation process.

 

Refer to the solutions in these articles to troubleshoot any discrepancies that may arise when reconciling your account:

If you have other banking or reconciliation concerns or need assistance navigating through QuickBooks Online, feel free to share your comments below. The Community is here 24/7 to assist you.