Skip to main content
June 9, 2022
Question

No audit trail for source of bank feed vs bank import - help!

  • June 9, 2022
  • 1 reply
  • 0 views

Hi 

 

A client set up a bank feed from a date earlier than I had asked and it ended up duplicating the transactions in Banking as I had already imported some of them.

 

Clearing up the mess (ie excluding them) wouldn't have been so difficult, had we not already selected "auto post" for many of the bank rules and hence many "randomly" posted duplicates were sitting in Categorised. 

 

Of course this doesn't happen every day, but what I am about to suggest would be a key "Audit trail" feature for the Banking section in QBO : a "Source" column.

 

In other online bookkeeping software (see image below), the bank statement (or in QBO terminology the For review, Categorised and Excluded pages) shows the SOURCE of every transaction - either bank feed or imported

 

Without this, if there are duplicated transactions from say a an Imported file, followed by a Bank Feed overlap or two files Imported with overlapping dates, then you WILL NOT be able to easily track the duplicates under the "For review" tab or the "Categorised" tab - without a lot of difficulty (using Last modified on the Account transaction report for the Bank account will only help to identify them, not exclude them quickly!)

 

This needs to be sorted asap please.

 

See example from other software below:

 

1 reply

June 9, 2022

Hello JasonGrant, welcome to the Community page, thanks for this feedback we will pass this straight on to the developers.