Accounting imports · Updated
Odoo 19: bank import remains in the suspense account
Inspect Bank Matching counterpart items, partial balances and model effects in Odoo 19. A bank import or uploaded bill is not completed reconciliation.
Blog
Find your next banking workflow
Practical guides to statements, CSV conversion, and bookkeeping. Search by bank or choose a topic.
292 articles · Page 5/13
Accounting imports · Updated
Paddle Billing payout mismatch: filter by remittance reference
Build the Paddle Billing payout reconciliation report for one remittance reference, including balance-currency adjustments instead of only updated transactions.
Accounting imports · Updated
Patreon withdrawal history: wallet Complete is not bank credit
Read Patreon withdrawal attempts, wallet destinations and separate processing and payout fees before matching an actual bank credit.
Accounting imports · Updated
PayPal statement and Activity counts differ: check balance impact
Compare PayPal statement coverage with Activity Download, using balance impact, currencies, time zones and complete export parts rather than row counts.
PDF conversion · Updated
PDF Portfolio bank statements: extract the listed components
Use Acrobat desktop to extract PDF Portfolio components separately while retaining container origin, file types and a complete member inventory.
Accounting imports · Updated
Power Query cleanup went wrong: rebuild from raw columns
Keep source hashes, raw bank CSV columns and rule versions before lossy transformations. Compare field changes and rebuild rather than reverse a cleaned value.
Accounting imports · Updated
Power Query bank totals: retain the rows behind each group
Summarize bank transactions with Count and All rows alongside Sum, then prove group membership without deleting legitimate equal-value transactions.
Accounting imports · Updated
Power Query refresh overwrites review labels: use a keyed table
Keep bank transaction review labels outside refreshed output, then rejoin by a verified stable key and check duplicates, missing labels and orphan records.
Accounting imports · Updated
Split a bank CSV by account: prove complete row coverage
Create account-and-currency working copies only from verified labels. Check disjoint row identities, unknown-account quarantine and complete source coverage.
Accounting imports · Updated
QuickBooks employee cards: reconcile the parent or subaccounts?
Choose the QuickBooks Online US connection level from issuer downloads. Check consolidated statements, static card balances and opening-balance overlap.
Accounting imports · Updated
QuickBooks: employee reimbursement after an expense is recorded
Trace the original employee expense, liability and reimbursement before matching a QuickBooks Online US bank payment. Avoid recording the expense twice.
Accounting imports · Updated
QuickBooks: changed reconciled records and beginning balance
Use QuickBooks Online US discrepancy reports and history to investigate changes to reconciled records before editing the next beginning balance.
Accounting imports · Updated
QuickBooks: trace a grouped deposit before explaining the bank gap
Use QuickBooks Online US Deposit Detail to trace grouped customer payments, existing fees and the actual bank receipt without recording income twice.
Accounting imports · Updated
QuickBooks: matched bank payment, but the invoice is still open?
Check QuickBooks Online US payment allocations and outstanding invoice amounts. A matched bank record does not prove every invoice was paid in full.
Accounting imports · Updated
QuickBooks first connection: opening balance or overlapping history?
Inspect a first QuickBooks Online US bank connection’s starting point and existing opening entries before treating equal amounts as a duplicate.
Accounting imports · Updated
Ramp CSV export: why did items leave the Accounting queue?
Distinguish Ramp reporting, preview and committed Accounting exports. Check integration, role scope and destination records before repeating an export.
Bank tutorials · Updated
Relay statements: check coverage across business accounts
Download Relay checking and savings statements with explicit account selection. Verify account-period coverage across web bundles and mobile downloads.
Bank tutorials · Updated
Rho: why an Expenses CSV is not your settled bank activity
Separate Rho pending card expenses, refunds and settled checking activity. Export a running balance for one account without filling missing values by guesswork.
Accounting imports · Updated
Shopify gift cards: why redemption is not another bank receipt
Distinguish Shopify gift-card sales, manual issuance and redemption before reconciling mixed-tender orders and cash received through payment providers.
Accounting imports · Updated
Shopify Payments deposit differs from sales: use the payout
Use the specific Shopify Payments payout transactions to explain a bank deposit. Separate activity reports, currencies, status and third-party providers.
PDF conversion · Updated
Signed bank statement PDF: preserve the original before OCR
Record Acrobat signature validation, certificate and timestamp details on the original, then distinguish an authorized OCR workcopy from signed evidence.
Accounting imports · Updated
Square US: identify the location behind a bank transfer
Use Square Dashboard transfer history, location context, cutoff timing and available trace details to investigate a shared-bank-account deposit.
Accounting imports · Updated
Stripe payout differs from sales: trace the itemized report
Trace an automatic Stripe payout through fees, refunds, disputes and retries. Keep manual and instant payouts outside unsupported transaction assignments.
Accounting imports · Updated
Stripe Connect: platform or connected-account payout report?
Choose the correct Stripe Connect report scope before matching a bank deposit. Separate application fees, connected balances and account access.