Audrey

Stop the frustration!
Free Bank Reconciliation in Seconds

What does Audrey do? It matches them line by line and tells you what is left over and why.

Wait a minute... what about the sensitive data on the uploads? Your files are processed to produce your report and then deleted. We keep no copy, and there is no account. Holding your files would be a liability for us, so we don’t keep them. Audrey matches on dates, amounts and descriptions. It never reads account numbers, EINs, SS# or addresses, so black those out before uploading if you prefer. Either way, the files are gone once your report is emailed.

So, why is this free? We want you to consider us for your payment processing needs.

The two files

A general ledger transaction detail report for one cash account, exported as CSV or Excel (.xlsx only). Not a trial balance or a summary — Audrey needs one row per transaction. A PDF will not work here yet — if that is all you have, email it to audrey@brooksidepayments.com and we will take a look.
Not sure which report that is?

Whatever your system calls it, you want the one that lists every transaction on a single cash account, one row each. Names change between versions, so the shape matters more than the label.

QuickBooks Transaction Detail by Account, or a QuickReport on the cash account
TylerMunis, Incode, New World, ERP Pro Account Inquiry, or General Ledger Account Detail
BS&A GL Account Detail, or the account inquiry export
SpringbrookNames vary, but look for a report with Detail or Transaction in it, run against one cash account.

Not a Trial Balance, not a Balance Sheet, not anything called Summary — those give totals, and totals cannot be matched line by line.
Caselle
Black Mountain
CentralSquare
gWorks, Xero, anything else

Four things to set when you run it, because each one breaks the reconciliation in a different way:

  1. One bank account, not pooled or combined. The statement covers one account, so the books have to as well.
  2. Every source, not just the counter. Cheque runs and payroll are most of the money going out.
  3. Detail, not totals. A report grouped by day has already done the grouping, and done it wrongly for this purpose.
  4. Run the dates about a week past the period end. Something banked on the 30th that cleared on the 2nd is timing, not a missing entry.

Still not sure? Email audrey@brooksidepayments.com and say which system you use.

Downloaded from your bank as CSV, Excel (.xlsx only) or OFX. Most banks offer these under "export" or "download transactions". QFX and QBO are OFX under another name and work too. If OFX or QFX is offered, take it — it carries the closing balance and the cheque numbers, so Audrey has to guess at nothing. A PDF will not work here yet — if that is all you have, email it to audrey@brooksidepayments.com and we will take a look.

The period (optional)

Leave these blank and Audrey takes the period straight from your statement. Fill them in only if you want a narrower range.

Leave blank if you like — but this is what proves the file was read correctly, and without it the result is marked unverified.
From the top of the statement, not the transaction list.

Before you reconcile, please note the following

Audrey compares two files and reports the differences. It is not an audit, not an attestation, and not accounting or legal advice. Brookside Payments is not your accountant.

Any correcting entries shown are drafts for your finance officer or accountant to review. Nothing is posted anywhere. A reconciliation that balances is not proof that either record is correct.

Provided as is, with no warranty. Full terms: Disclaimer, Terms of Use, Privacy Policy.

Audrey is a free tool from Brookside Payments. It is not an audit, not an attestation, and not accounting or legal advice. Ask us about our payment processing (no cost for local government and low cost for small business). We also offer free cashiering and accounting systems tailored to governments. audrey@brooksidepayments.com  ·  (833) 382-1992
Disclaimer  ·  Terms of Use  ·  Privacy Policy