Reconcile balances with QuickBooks or SAP

Reconciliation compares each customer's balance (receivables) and each vendor's (payables) in QuickBooks or SAP with thruflow's, to the cent. A balance is what's owed on open invoices or bills, less unused credit memos, vendor credits and money on account. QuickBooks is read afresh each time the page opens; Read QuickBooks again reads it once more.

Where the two differ, the difference is put down to the documents behind it, and the items always add up to it exactly. Why they differ shows it reason by reason; click one to see its customers or vendors. Open a row to see each document here and there, what differs and how to settle it.

Differences that clear by themselves

• Posted, not sent yet: an invoice counts in thruflow from the day it's sent, but in QuickBooks or SAP from posting. Send it and the difference goes.
• Approved, not posted yet: a bill counts in thruflow once it's approved. Post it and the difference goes.

Differences that need a person

• Paid there, not here: a payment recorded in QuickBooks. Sync payments brings it over.
• Paid here, not there: a payment deleted in QuickBooks, or one that never reached it. Enter it there against the same invoice.
• Only there: an invoice or bill entered directly in QuickBooks or SAP. Bring into thruflow records it here, linked, with what's been paid on it there.
• In both, not linked: the same document keyed into both. Link them, so it isn't posted twice and payments pass between them.
• Total differs or Edited after posting: usually tax worked out differently, or a change made there. Correct it there to match.
• Void or deleted there, Void here: void it on the other side too.
• Under another customer: move it to the right customer there, or link the customer here to the one it's under.
• Journals and other entries: what no document explains, such as journal entries or an opening balance. Look at the customer's transactions there.

Find out why

Open a row that differs and press Find out why. thruflow reads that customer or vendor afresh and tells it as a case: one sentence saying how much and the main cause, when the two stopped agreeing (from the morning balance checks), then each cause, largest first, with when it happened, who did it, and its fix (one click where it takes one), and what happened on each side, in order.

• From QuickBooks it reads when each document there was created and last changed, and its own Customer or Vendor Balance Detail report, so journal entries and other entries are named, dated and summed instead of shown as one total.
• From thruflow it reads the audit trail of each document in the row.
• With AI on, Claude may write the sentence and the story. They're used only if every amount, date and document they mention is in the records; otherwise the rule-written ones are shown, and you're told why.