Bank tutorials · Updated
Tide UK: cleared CSV, monthly statement or custom PDF?
Choose a Tide UK export with the right balance and period: cleared CSV, monthly PDF or a custom statement with its documented date and size limits.
Blog
Find your next banking workflow
Practical guides to statements, CSV conversion, and bookkeeping. Search by bank or choose a topic.
292 articles · Page 6/13
Accounting imports · Updated
Wave cannot read a CSV: columns, card signs and currency
Check Wave US statement-upload fields, credit-card signs and destination currency before preparing and uploading another bank CSV.
Accounting imports · Updated
Wave duplicate connections: check every included account
Distinguish a duplicate Wave US connection from one duplicated account. Review import toggles, existing history and dependencies before removal.
Accounting imports · Updated
Wave Payments: a bank payout is not another sale
Trace Wave US online invoice payments through Money in Transit to a grouped bank payout, without recording the same income twice.
Accounting imports · Updated
Wise to Xero: prepare older history by currency and date
Separate Wise’s 12-month sync lookback from its 365-day statement limit. Plan per-currency history and check Xero overlap before uploading old records.
Accounting imports · Updated
Xero Australia: an ABA file does not prove the bank paid
Separate a Xero Australia batch’s Paid status, payment file and actual bank execution. Compare supplier grouping before calling a bill missing.
Accounting imports · Updated
YNAB file import: account, CSV preview and mobile limits
Use YNAB’s current file-import preview on the web or a supported iPad. Check account, amount mapping and starting-balance dates before import.
Accounting imports · Updated
YNAB: imported card payment looks like spending
Check payment-account and card-category selection in YNAB’s current web workflow. Separate an in-plan card repayment from money arriving outside the plan.
Accounting imports · Updated
Zoho Books: one bank deposit, several customer payments
Check existing customer payments versus unpaid invoices before matching a grouped deposit in Zoho Books US. Keep unexplained shortfalls separate.
Accounting imports · Updated
Zoho Books: complete the earlier saved reconciliation
Find the In-Progress period blocking another Zoho Books US reconciliation. Check the account, saved dates and closing balance before completing it.
Accounting imports · Updated
Zoho Books: Unmatch or Uncategorize a wrong bank line?
Check the different effects of Unmatch and Uncategorize in Zoho Books US before correcting an existing bank association.
Accounting imports · Updated
Fix ambiguous dates and decimal separators in bank CSV files
Resolve ambiguous bank CSV dates and decimal separators using known source conventions, per-column locale and a raw-to-converted review table.
Accounting imports · Updated
Bank CSV opens in one column or shows garbled text: fix the import
Diagnose CSV delimiters, quoted fields and UTF-8 decoding with a synthetic four-column example. Keep accented descriptions and leading-zero references intact.
Accounting imports · Updated
Combine bank CSV files with Power Query in Excel for Windows
Combine reviewed bank CSV files in Excel for Windows. Preserve filenames and per-file record numbers, quarantine exceptions and check refresh results.
Accounting imports · Updated
Review duplicates across overlapping bank CSV exports
Review overlapping bank CSV exports with source-record evidence. Distinguish repeated copies from genuine payments and hold unresolved matches.
Accounting imports · Updated
Import a bank CSV into GnuCash: map fields and review matches
Import a bank CSV into GnuCash 5.17 on Windows: choose the base account, map signed amounts and inspect transfer accounts and proposed matches.
Bank tutorials · Updated
Mercury: monthly QuickBooks CSV or filtered transaction export?
Choose Mercury’s monthly QuickBooks CSV or a filtered export for historical bookkeeping. Check account, period, omitted income and existing records.
PDF conversion · Updated
Power Query: rebuild bank-PDF transactions split across rows
Rebuild multiline bank-PDF transactions using verified source-row boundaries. Preserve cross-page descriptions and avoid duplicating amounts in Power Query.
Accounting imports · Updated
Power Query Merge repeats bank amounts: check invoice matches
Diagnose repeated bank amounts after merging with invoices. Count nested matches, preserve valid allocations and separate bank-event and invoice totals.
Accounting imports · Updated
QuickBooks: a card repayment appears in both connected accounts
Review a credit-card repayment in QuickBooks Online US. Distinguish an existing payment from two downloaded legs before matching or recording it.
Accounting imports · Updated
Xero Statement balance differs from the bank: find the interval
Compare Xero’s Statement balance with the bank at the same cutoff. Check opening balance, narrow the differing interval and inspect statement exceptions.
Bank tutorials · Updated
AIB Ireland: account and credit-card statement PDFs
Find AIB Irish card or account statements in the right app version, allow the card order’s production time and close separate document windows after use.
Bank tutorials · Updated
Alliant: statement PDFs or native account downloads
Use Alliant’s account Download popup for a selected timeframe and offered format, or save an eStatement. Keep the 18-month statement window separate from export history.
Credit card tutorials · Updated
Amex UK: billing statements, recent activity and paper delivery
Open UK American Express billing PDFs, distinguish six-month app transaction search from statement history and manage delivery through the correct settings.