Accounting imports · Updated
Xero transfer matched on one side: inspect the other account
Separate Xero’s existing transfer counterpart from a missing, unmatched or linked destination bank statement line before recording another transfer.
Blog
Find your next banking workflow
Practical guides to statements, CSV conversion, and bookkeeping. Search by bank or choose a topic.
292 articles · Page 3/13
Bank tutorials · Updated
YouBiz: pair currency-account PDFs with transaction logs
Keep YouBiz account identity and currencies separate: single-account PDFs, multi-account CSV/XLS logs and restricted employee card views serve different requests.
Accounting imports · Updated
Zoho Books foreign-currency payment residual: which evidence to collect?
Collect base, customer and bank currencies, the applied rate and actual charge evidence before attributing a Zoho Books US-EN payment residual.
Accounting imports · Updated
Actual CSV: Amount and Split_Amount are different totals
Check Actual v26.10.0 query-export parent and child amounts. Keep CSV controls separate from raw CLI/API records to avoid counting a split twice.
Accounting imports · Updated
Actual Budget merge: preserve manual payment notes
Check which Actual transaction survives a merge and preserve conflicting notes before combining an imported row with a confirmed manual payment.
Accounting imports · Updated
Adyen MerchantPayout: reconcile the row without counting twice
Use the Settlement details report’s merchant, batch and currency to explain MerchantPayout Net Debit, excluding the payout row from its own amount bridge.
Accounting imports · Updated
Airbnb UK: whose payout records explain the bank credit?
Separate owner and co-host payout evidence, report access and destination records. Check UK hosting-program restrictions before assuming a split is available.
Accounting imports · Updated
Amazon Marketplace US: settlement balance or bank receipt?
Separate reserve and deferred balances from an initiated Amazon Marketplace disbursement, then use available trace details for a missing bank credit.
Accounting imports · Updated
Amazon Pay US: paid order but a different bank settlement
Trace Amazon Pay order references through a full settlement report, retaining refunds, fees and reserves instead of summing captured orders alone.
Accounting imports · Updated
App Store Connect: fiscal report versus bank payment CCI
Download Apple financial reports for the correct fiscal month and entity, then distinguish estimated proceeds from the issued bank payment and CCI reference.
Bank tutorials · Updated
Aspire Singapore: employee card data or the full account record?
Check Aspire Singapore export roles, single-account statements and payroll-detail access before treating an employee’s card CSV as a complete company record.
Accounting imports · Updated
Banana Accounting: Swiss CAMT extension or text import?
Choose the documented Swiss CAMT extension or Banana’s simple tab-separated text route. Check edition, schema, fields and counter-account effects.
Privacy & workflows · Updated
Bank CSV descriptions starting with =: import them as text
Keep formula-like bank descriptions separate from numeric amounts, use Excel’s documented text import and verify the saved working copy.
Accounting imports · Updated
Bank CSV near midnight: compare explicit offsets to cutoff
Normalize offset-qualified transaction instants before comparing a defined cutoff. Keep posting dates, missing offsets and daylight-saving rules separate.
Privacy & workflows · Updated
Bank CSV support request: build a synthetic failing example
Create an invented CSV that preserves a quoting or delimiter failure, without sending a client statement or accidentally removing the original symptom.
PDF conversion · Updated
Bank statement PDF missing a page? Compare printed folios
Compare physical PDF positions with printed statement folios. Record a specific missing-page request and keep incomplete sources out of full-month claims.
PDF conversion · Updated
Bank statement PDF pages out of order: build a folio map
Use printed page identities to establish an unambiguous order before moving Acrobat thumbnails in a working copy; hold missing or duplicated folios.
Accounting imports · Updated
Are bank statements missing? Check period coverage in Excel
Compare stated coverage dates against the required calendar, including inactive days, without mistaking overlapping files for duplicate transactions.
Accounting imports · Updated
Statement ZIP files share filenames: inventory before extracting
Use separate PowerShell extraction destinations and content hashes to distinguish same-name statements, duplicate bytes and unresolved account-period identity.
Accounting imports · Updated
Beancount: check a statement close at the next day’s opening
Test Beancount balance dates with five executed synthetic controls: cutoff-day transactions, next-day exclusions and physical file order.
Bank tutorials · Updated
Brex: card statement, Banking statement or expense report?
Choose the right Brex document for a card cycle, cash account or spend review. Preserve entity, period and role scope without confusing account letters.
Privacy & workflows · Updated
A replacement bank PDF differs: compare both issued versions
Keep both statement originals and use Acrobat Pro comparison deliberately; equal totals or different hashes do not identify the corrected transactions.
Accounting imports · Updated
eBay US payout CSV: order rows are not extra item receipts
Distinguish eBay order, item, reference and payout identifiers. Keep fees and adjustments while avoiding double-counting multi-item order rows.
Accounting imports · Updated
ERPNext: bank row imported but Payment Entry is missing
Distinguish a Bank Transaction from an existing submitted payment voucher, reconciliation and General Ledger posting in ERPNext’s documented workflow.