Accounting imports · Updated
Etsy UK deposit differs from net profit: check availability
Use Etsy monthly statement CSV, deposit interval and funds availability to explain a UK shop deposit without treating reserve release as another sale.
Blog
Find your next banking workflow
Practical guides to statements, CSV conversion, and bookkeeping. Search by bank or choose a topic.
292 articles · Page 4/13
Accounting imports · Updated
Excel PivotTable omits new bank rows after refresh
Inspect a normal PivotTable’s source range separately from Refresh. Equal totals can conceal new offsetting transactions outside the configured range.
Accounting imports · Updated
Excel sorted only amounts: rebuild the bank CSV rows
Detect partial-column sort damage using complete source tuples, not totals. Restore from a retained CSV rather than guessing which equal amount belongs where.
Accounting imports · Updated
Firefly III: pair a CSV configuration with duplicate checks
Check Data Importer column roles, instance-specific mappings and duplicate mode together before reusing a Firefly III CSV configuration.
Accounting imports · Updated
FreeAgent bank balance: import cutoff or starting point?
Compare FreeAgent UK balances at the last cleared import and review start-date coverage before changing a client’s opening balance.
Accounting imports · Updated
FreeAgent rental statement: match the agent’s net transfer
Review FreeAgent UK’s native landlord statement workflow and match the generated transfer to the main bank without recording the rent twice.
Accounting imports · Updated
FreeAgent Undo last upload: check order and attachments
Check the selected account, reverse upload order and attached files before authorizing a FreeAgent UK statement-upload correction.
Accounting imports · Updated
FreeAgent: upload succeeded but transactions are unexplained
Distinguish a FreeAgent UK bank upload from reviewed accounting explanations. Check access, Guess suggestions and supporting documents.
Accounting imports · Updated
FreshBooks CSV: expense import or bank reconciliation?
Choose the FreshBooks CSV destination, check early-history starting points, and track non-overlapping segments without repeating existing expenses.
Accounting imports · Updated
GnuCash card reconciliation: check the balance display
Check a credit-card liability, GnuCash’s balance-display preference and the issued statement before choosing the reconciliation ending-balance sign.
Accounting imports · Updated
GnuCash Trading accounts: check both bank currencies
Trace the original currency amounts of a GnuCash bank transfer. Separate Trading entries, conversion reports, received amounts and evidenced fees.
Accounting imports · Updated
GoCardless UK: payout Transactions or Events export?
Use the GoCardless payout breakdown to distinguish current payment status from payout events while keeping fee rows in the net amount bridge.
Accounting imports · Updated
Google Play: earnings report differs from the bank payout
Choose earnings rather than estimated sales for a Google Play payout investigation; separate report time zones, signed adjustments and payment-profile records.
Accounting imports · Updated
Gusto US payroll: why several bank debits differ from net pay
Separate Gusto payroll debits, check-date summaries and billing records. The Bank transactions report does not offer a CSV download.
Accounting imports · Updated
hledger CSV: do the rules import amounts or balances?
Review hledger 1.52 amount1, balance1 and account rules with a complete-file preview before using the separate new-transaction dry run.
Accounting imports · Updated
hledger import skips an older CSV correction: check .latest
Inspect hledger 1.52 date-and-count overlap tracking alongside a full-file preview. Renaming a file or deleting .latest is not a safe deduplication fix.
Accounting imports · Updated
HomeBank CSV: map payment codes without inventing transfers
Map bank payment meanings to HomeBank’s eight-field CSV and inspect code 5’s internal-transfer limitation. Keep export-only columns out of the import layout.
Accounting imports · Updated
ING MT940 v4 Strategic: join wrapped :86: references safely
Interpret ING InsideBusiness Connect Structured MT940 v4 Strategic v6.0 continuation lines, preserving transaction context and separating the closing summary.
Accounting imports · Updated
KMyMoney CSV: Banking or Investment for cash records?
Choose a KMyMoney 5.2 CSV importer profile from the actual data and destination account, rather than the broker’s name or a three-column cash file.
PDF conversion · Updated
Mac Preview: split a multi-account bank PDF into working copies
Preserve the original bank PDF, select verified account pages in Preview and retain shared summaries with an original-to-working-copy page map.
Accounting imports · Updated
Mollie settlement missing at month-end: follow the reference
Match the actual Mollie settlement reference, account, amount and currency across different settlement and bank-posting dates; interpret MT940 scope correctly.
Accounting imports · Updated
MoneyWorks: inspect statement defaults before loading bank history
Check MoneyWorks Statement Coding Bank, Source, cutoff dates and remembered defaults. Auto-Reconcile changes omission and reconciliation states, not just the view.
Accounting imports · Updated
MYOB Australia: browser or AccountRight statement-import route?
Separate MYOB browser Banking hub from AccountRight Desktop Get Statement. Check opening boundaries, lock dates and existing feeds before importing history.
Bank tutorials · Updated
Novo: monthly statements or an Activity CSV for your bookkeeper?
Get the right Novo US account record: complete-month statements, custom Activity CSVs and different web or app history windows.