Find the outcome you need.
Start with a symptom, a platform or the thing you want working.
With JavaScript, search filters the whole collection in your browser. Without it, use the linked pages and section navigation below; query filters need JavaScript.
Showing entries 361–400 of 651 in this first collection.
Buyer collection
For an office manager: sort your PDF, scan and old-file jobs into do it yourself, buy, or leave
List the jobs by what the file actually is, find the ones your own software already handles, and ask for outside help only where volume, repetition or the need for a checked record justifies it.
Buyer collection
For an operations lead: stop rebuilding the weekly report by hand, or decide to hand it over
Work out what the report actually costs you in steps, put the method in writing, decide whether to template it yourself or hand it over, and choose checks that show each pack matches its export.
Collection
A messy workbook: the order to diagnose it in, and where each fix leads
Seven checks in a fixed order, from stale calculation to import readiness, each pointing to the guide that explains it and the checked job that covers it if you would rather not do it yourself.
Collection
From a PDF to a checked spreadsheet: the order of questions that saves the most effort
Seven steps from "does it have text?" to "who signs off the exceptions?", linked to the guides, the worked example and the checked jobs, including what to do when the same document arrives every month.
Troubleshooting guide
Excel shows #REF! or #NAME?: work out which kind of broken formula you have
Each Excel error value points to a different kind of break. Learn what they mean, how to trace a formula back to its inputs, and why hiding the error is not a repair.
Troubleshooting guide
Totals look wrong but Excel shows no error: stale calculation, text numbers and displayed versus stored values
When no error appears, three quiet causes explain most wrong totals: manual calculation, numbers stored as text and rounding that is displayed but not stored. Here is how to tell which.
Troubleshooting guide
Merged cells stop Excel sorting and pivoting: how to flatten a printed-style report safely
Merged group labels, spacer rows and subtotal lines make a report readable on paper and unusable as data. See what merging does, what a flat table needs and how to prove nothing was lost.
Troubleshooting guide
Dates sort wrongly or change between computers: serial numbers, text dates and day-month order
Excel stores dates as numbers and reads typed dates through regional settings. Learn how text dates, a four-year offset and day-first entries produce wrong sorting, and what to do with rows that cannot be settled.
Troubleshooting guide
Cleaning duplicates in a contact list: write the match rules before you delete anything
Removing duplicates is a set of decisions, not a button. Compare exact and near matches, avoid merging people who only share a field, and keep a log so every merge can be undone.
Troubleshooting guide
Old .doc and .xls files: what converting really changes and how to check a whole batch
Converting one old Office file is easy. Converting a folder needs an inventory, copies instead of overwrites, a decision about macros and a check that the new files match the old.
Troubleshooting guide
Renaming thousands of files: rules, collisions, path limits and a manifest that proves nothing changed
A bulk rename can overwrite files, break on reserved names or exceed path limits. A dry run, a rule check and a checksum manifest make it safe and reversible.
Troubleshooting guide
Mail merge and quotation templates: why numbers arrive wrong and how to test a batch
A merge copies cell values into a template. Currency symbols, percentages and codes come through differently from how they look, so calculations and formats must be settled before the merge.
Troubleshooting guide
Rebuilding the same report every week or month: how to make it repeatable and checkable
A recurring report drifts when it is rebuilt by hand. Fix the export contract, make refreshing change only the data, and add control totals so each period can be checked against its source.
Troubleshooting guide
Before you import a spreadsheet into another system: the checks that stop a failed load
Loads fail on blanks, types, dates, codes and keys. A column-by-column readiness sheet, the right CSV handling and a test on a copy catch most problems before they reach a live system.
Troubleshooting guide
Can this PDF be read as data? Check for a text layer before you plan an extraction
A PDF can hold selectable text or only a picture of each page. A two-minute test tells you which, and that decides the method, the checks and what anyone can honestly promise.
Troubleshooting guide
How to check a PDF extraction is right: count, compare, and list what could not be read
Extraction mistakes are silent. Counting rows page by page, comparing a pre-chosen sample and keeping an exceptions list shows where a spreadsheet differs from its document.
Troubleshooting guide
Filled-in PDF forms: where the answers live and when they are really gone
Answers typed into a fillable PDF are stored as named fields inside each file. Learn how to tell whether a returned form still has them, and how to decide what checkboxes and blanks become in a spreadsheet.
Troubleshooting guide
A scanned PDF cannot be searched: what text recognition can fix and how to test it
Scanning produces pictures of pages. Text recognition can add a hidden text layer, but quality depends on the scan. Test it with words you know are on known pages rather than trusting a percentage.
Inspectable example
Synthetic Stripe payout: five charges, two refunds, one deposit and a clearing balance that returns to zero
A worked, invented payout shows how gross charges, fees and refunds add up to the single bank deposit and what ledger entries make the bank line match.
Inspectable example
Synthetic mapping table: eight categories and what a sync should do with each
An invented category-to-account table shows mapped, unmapped, archived, renamed and reused-code cases, with the disposition a checked mapping should give each line.
Inspectable example
Synthetic monthly drift list: one duplicate, one missing refund and one timing item
An invented month shows how matching by identifier turns two differing totals into three itemised, explained or open differences with a named next step.
Inspectable example
Synthetic foreign-currency check: the same 100.00 USD order with Xero-style and QuickBooks-style rates
Invented arithmetic shows how a copied, inverted or default rate changes the base total, and how treating minor units as whole units shrinks a yen amount a hundredfold.
Troubleshooting guide
Xero and QuickBooks request keys help a retry, but not for as long as you might think
Compare what Xero's Idempotency-Key and QuickBooks Online's request id protect, for how long, and why a stored order identity and a lookup remain the lasting control.
Troubleshooting guide
Duplicate Xero contacts: choose the identity your sync matches on before cleaning anything
Separate Xero's ContactID, ContactNumber, name and account number, and design a match order that survives a changed email, a same-name pair and an archived contact.
Troubleshooting guide
QuickBooks "Stale Object Error": the version token your update used is out of date
Understand SyncToken, why a sync keeps an old one, and how read-before-write, sparse updates and a written conflict rule remove intermittent update failures.
Troubleshooting guide
A bulk Xero job loses orders when it meets a rate limit: pace it and keep a checkpoint
Read Xero's limits, understand why a 429 or a batch response can silently drop orders, and design pacing, per-item checks and a checkpoint so every order ends created or held.
Troubleshooting guide
One Stripe deposit, many sales: why the bank line matches nothing in the ledger
Explain how an automatic Stripe payout bundles charges, fees and refunds into one net deposit and how a clearing account and a payout-level entry make the bank line match.
Troubleshooting guide
PayPal sales reach the ledger but refunds and fees do not: reconcile three separate records
Treat a PayPal sale, its refunds and its fees as linked but separate records, read amounts from PayPal rather than recomputing them, and hold a refund until its sale exists.
Troubleshooting guide
PayPal webhooks can repeat and arrive late: make the ledger update safe to repeat
Use PayPal's delivery contract to design an event inbox with a unique event id, raw-body verification, held dependent events and a report-based safety net.
Troubleshooting guide
A PayPal report export leaves gaps: 31-day windows, a three-hour delay and a per-request record cap
Plan non-overlapping report windows with a lag, page through every result, deduplicate, and treat a too-large error as a signal to shrink the window, so an export or replay neither misses nor repeats PayPal transactions.
Troubleshooting guide
Which ledger account does this line post to? Replace hard-coded codes with a checked mapping table
Design a category-to-account table keyed by account identifier, validated against the live chart before each run, with no default account and a held list for gaps.
Troubleshooting guide
The same exchange rate means opposite things in Xero and QuickBooks Online: check direction and units
Compare how Xero and QuickBooks Online express rates, why a copied rate inverts the base total, why a default of one is wrong, and how currency minor units cause factor-of-100 errors.
Troubleshooting guide
Expenses import as bills but the receipts are missing or on the wrong bill
Link expense, bill and receipt through one expense id, attach files after the bill exists within Xero's limits, and make a re-import safe, with draft-only creation.
Troubleshooting guide
A scheduled Google Sheets export stops at the same row or shows old numbers: check limits and state
Understand Apps Script run-time and daily trigger limits, trigger ownership, Sheets API quotas and locks, and design a staging swap and status block so failures are visible.
Troubleshooting guide
Reading Xero invoices: paging, itemCount and If-Modified-Since so a report is complete
Use Xero's paging defaults, pagination object and If-Modified-Since header to read every invoice, advance an incremental watermark safely and prove completeness.
Troubleshooting guide
A Xero sync that quietly stopped: refresh tokens, quiet spells and parallel refreshes
Understand Xero's token lifetimes, why an infrequent or parallel integration loses its connection, and what the connection owner must do, so a stopped sync is noticed at the next check.
Troubleshooting guide
Reconciliation drift: six kinds of difference between a payment processor and a ledger
Classify differences as missing, extra, amount, duplicate, timing or currency, match by identifiers rather than totals, and decide what is escalated before a monthly list is trusted.
Platform
Xero integrations: identity, limits, accounts and currency decide whether a sync can be trusted
What Xero documents for integration builders (contacts, invoice numbers, idempotency, paging, limits, accounts, lock dates, demo company) and which failures map to which guide or outcome.
Platform
QuickBooks Online integrations: version tokens, request ids, throttles and one shared name space
What Intuit documents for QuickBooks Online integrations (SyncToken, request id, throttling, unique display names, multicurrency, sandboxes) and which failures map to which guide or outcome.
Platform
PayPal in your ledger: webhooks that repeat, a report with windows, and refunds with their own fees
What PayPal documents for reconciliation (webhook retries, raw-body verification, report limits, capture and refund breakdowns) and which failures map to which guide or outcome.