Clearing the duplicate rows a feed backfill leaves behind
A feed goes down, somebody fills the gap with a QFX file or a spreadsheet upload, and then the connection comes back and delivers the same period again. QuickBooks Online recognises the overlap only when date and amount agree exactly, so a charge that posted a day after it pended reads as a fresh transaction. The upload path caps out around a thousand rows per file, which means a long gap arrives in pieces, each with its own seam. The reconciliation difference at month end is usually the sum of those twins.
Everything is finished and the return still cannot be filed, because the signature authorisation has not come back.
The trial balance is the centre of this work, and most of the repeated labour is getting source material into a shape the trial balance can accept. Statements arrive as PDFs, receipts arrive as photographs, and bank data arrives through an aggregator that authenticates against a bank which changes its login flow without notice.
- QuickBooks Online
- Xero
- Excel
When this is the wrong thing to build
Pick something else if the gap was closed by a single summarising journal entry rather than an import, because then there is no row level source to match against and the period has to be rebuilt from the statement instead. Deleting duplicates inside a closed and reconciled period is also a different job with a different risk.
The constraint that shapes it
Tax return information is governed by a statute that makes disclosure or use outside preparation a criminal matter, with a parallel civil penalty, and consent has to be obtained in a prescribed form naming the recipient and the purpose. More on how this sector works.
Two sources of truth. One queue of the rows that do not line up. Read what this shape is, or start from one of these.
- Rebuilding an annual operating expense reconciliation from the lease
- Reconciling a broker trust account three ways every month
- Matching a closed transaction back to the lead that produced it
- Collapsing two overlapping MLS feeds into one property list
- Widening a conflicts search past exact spelling
- Rebuilding a billable day from the trail the systems already keep
- Why does QuickBooks import the same bank transactions twice after reconnecting?
- How do I find duplicate transactions created by a CSV bank import?
- How do I clean up a double import after a bank feed reconnects?
- Why does my reconciliation difference equal a batch of duplicate transactions?
- What start date should I pick when reconnecting a bank feed?
Back to accounting and bookkeeping, or see how this is priced and scoped.