Guides & articles – page 11
Accounting software11 min read
Fix Duplicate Transactions in QuickBooks After Import
Why bank imports create duplicate transactions in QuickBooks Online and Desktop, how to find them quickly, remove them safely and prevent repeats.
Accounting software11 min read
Import Bank Statements into QuickBooks Desktop
How to import bank statement files into QuickBooks Desktop with Web Connect (QBO) or IIF, link accounts, review in Bank Feeds and reconcile.
Accounting software11 min read
Import Bank Statements into QuickBooks Online
Step-by-step: import bank statement files into QuickBooks Online, choose CSV or QBO, map columns, review transactions and reconcile the result.
Reconciliation11 min read
How to Find Bank Reconciliation Discrepancies Fast
A systematic way to find why a bank reconciliation won't balance: the divide-by-two and divide-by-nine tricks, timing items, duplicates and Excel checks.
Accounting software11 min read
QBO vs IIF vs CSV: Which File to Import into QuickBooks?
The differences between QBO, IIF and CSV files for QuickBooks bank imports, when to use each one, worked examples and how to avoid duplicates and errors.
Use cases11 min read
Using Bank Statements for Tax Preparation: A Checklist
How to organize a year of bank and card statements for your tax preparer: what to collect, how to summarize it, and the questions to answer first.
Use cases11 min read
Expense Tracking From Bank Statements: A Simple System
Track personal or business expenses using your bank statements: convert, categorize, review monthly and build reports in Excel or Google Sheets.
Reconciliation11 min read
Credit Card Reconciliation in Excel (With Template)
Reconcile credit card statements against your books or receipts in Excel: setup, matching formulas, timing differences, and a reusable template layout.
Accounting software11 min read
QuickBooks IIF Import: Bank Transactions Guide
How IIF files work in QuickBooks Desktop, the TRNS/SPL structure for bank transactions, a safe import process, and how to avoid costly mistakes.
Guides & comparisons11 min read
OCR for Scanned Bank Statements: Getting Accurate Data
How to scan or photograph bank statements so OCR reads them accurately, which digits get misread, and how to verify the results before use.
Guides & comparisons11 min read
Power Query for Bank Statements: PDF and CSV to Excel
Use Excel Power Query to import bank statement PDFs and CSVs, combine months from a folder, clean columns and refresh with one click.
Accounting software11 min read
Xero Bank Statement CSV Import Format, Explained
The CSV layout Xero expects for bank statement imports, how to map columns, handle dates and signs, and fix the errors we see most often.