Bank reconciliation QuickBooks exports, matched to any statement
QuickBooks reconciles well when the bank feed works. When it does not, when the statement is a PDF, or when you work in many client files, export the account from QuickBooks and let BankReconciler do the matching.
QuickBooks export
Transaction Detail by Account
214 rows
- Date Date
- Transaction Type Type
- Num Check or document number
- Name Payee
- Memo/Description Description
- Amount Signed amount
Columns detected
Ready to match
When to reconcile QuickBooks outside the bank feed
- The bank feed is disconnected or missed a few days of transactions
- The bank only sends a PDF statement
- You are cleaning up months of unreconciled history
- You reconcile clients in different QuickBooks files and want one board for all of them
- Your reviewer wants a reconciliation report with every item listed
Export from QuickBooks Online
- Open Reports and choose Transaction Detail by Account.
- Set the report period to the statement month, plus a few days on each side.
- Filter the report to the bank or card account you are reconciling.
- Export the report to Excel.
- Upload the XLSX file as Your books, next to the bank statement.
The account register export from the chart of accounts works as well.
Export from QuickBooks Desktop
- Open Reports, Accountant and Taxes, and choose Transaction Detail by Account.
- Set the dates and filter to the bank account.
- Use the Excel button and create a new worksheet or a CSV file.
- Upload the file as Your books.
After the reconciliation
- Download the adjusting entries as CSV and import them, or post them by hand from the list
- Use the outstanding checks and deposits in transit list to tick the same items in the QuickBooks reconcile screen
- File the reconciliation report with the month end close
QuickBooks questions
Does BankReconciler change anything in my QuickBooks file?
No. It reads the export you upload. Nothing is written back to QuickBooks, you decide which adjusting entries to record.
Which QuickBooks export works best?
Transaction Detail by Account filtered to one bank account, exported to Excel. It has the date, number, payee, memo and amount for every line.
Can bookkeepers use it across many QuickBooks clients?
Yes. Each client gets its own workspace on the Business and Firm plans. See bank reconciliation for accountants.