Troubleshooting guide
A useful place to start, with a route to the related result.
Troubleshooting guide
A Zap runs, but fields are missing: trace the value from trigger to destination
Inspect one synthetic record through each step and separate missing input, transformation, permissions and destination validation.
Troubleshooting guide
One Sheets row becomes one Xero invoice line: check the line-item shape
Distinguish missing spreadsheet headers from multiple products mapped into one invoice line, using a disposable two-product acceptance case.
Troubleshooting guide
A Zap created the record twice: find which of five causes it was
Count the runs, then check for a second Zap on the same trigger, a self-trigger, a replay and a plain create step before you change anything.
Troubleshooting guide
A Zap stopped or shows Errored or Halted: what each status means and what to replay
Read the run status first, understand why a Zap turns itself off, and know what a replay repeats and why error emails can arrive hours late.
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.
Troubleshooting guide
Invoice values look right in Sheets but arrive as currency text or a date number
Separate a spreadsheet's displayed currency and date from the values a connector reads, then agree the destination types before repairing a mapping.
Troubleshooting guide
An invoice integration adds tax twice: agree whether each amount is net or gross
Name the tax basis of each mapped line and the approved tax treatment before mistaking a populated amount field for a correct invoice.
Troubleshooting guide
Invoice creation timed out: reconcile the unknown result before retrying
Distinguish a confirmed rejected creation from a lost response after a possible write, and define zero, one and conflicting-match dispositions before a replay.
A need we have not covered yet?
Tell us what you need accomplished. We confirm whether we can offer a useful scope before accepting work.
Describe a custom outcome