Data and spreadsheets
Data, spreadsheets & business records
Clean, compare, match, validate, and prepare business records so the result is ready to use, review, import, or report on.
Cleanup & structure
- CSV and XLSX cleanup
- Repair broken headers and table structure
- Make column names, dates, currencies, statuses, and IDs consistent
- Review missing or invalid values
- Keep clean rows, problem rows, and rejected rows separate
Reconciliation, matching & duplicates
- Two-file and multi-file comparison
- Keyed CSV snapshot change audits with added and removed records, field-level changes, and reconciled counts
- Exact duplicate checks and probable duplicate matching
- When you provide confirmed examples, matching rules can be built from them
- Those rules are tested before automatic use; uncertain or conflicting matches stay separate for review
- Amount, status, and field mismatch detection
- Counts that account for every source row, plus mismatch reports
Spreadsheet formula checks, repair & reconstruction
- List and check formulas in a supplied XLSX workbook
- Check for links and formulas that depend on outside or changing sources
- Repair clear formula gaps and reconstruct missing or inconsistent formulas when the workbook clearly supports one formula
- Keep a cell-by-cell change log showing what changed and why
- If the intended business or accounting logic is unclear, it is flagged for clarification or left unchanged rather than guessed. Calculated results are not claimed as independently verified
Catalogs, databases & reports
- CRM, lead-list, product, SKU, inventory, and supplier-list cleanup
- Import-ready files with a clear guide to how columns map
- Queries and safe data moves for copied SQLite databases
- Move supplied data into an agreed structure
- Customer review and survey analysis
- Static HTML, Markdown, workbook, and operational reports
- Receivables aging from supplied single-currency invoice exports, with an agreed reporting date, invoice detail, and checked bucket totals
- Rule-based transaction categorization from a supplied CSV, with category totals and unmatched items for review
- Budget versus actual variance reports from two supplied CSV exports, with unbudgeted actuals listed separately
- Billable time summaries from supplied time-entry CSV files, using agreed rates and checked client or project totals
- Inventory reorder reports from supplied stock CSV files, using your reorder points and quantities to show shortfalls
- Sales summaries by product, customer, or region and by month, quarter, or year from a supplied CSV, with shares, ranks, and period-to-period change
- Gross margin reports from supplied revenue and cost files, by record and by product or customer, with loss-making lines marked
- Possible duplicate payment or invoice review lists from supplied payment CSV files, using the supplier, reference, amount, and day window you specify
- ABC ranking reports from supplied sales or stock values, using the cumulative percentages you choose
- Renewal and expiry tracking from supplied contract, licence, or certificate lists, with days remaining and an action list at your chosen date
These reports use defined rules and independently checked local calculations. No tax advice, payroll, accounting attestation, live ledger updates, purchases, or automatic system uploads are included. Sales, margin, and ranking reports use only the figures you supply, with no forecasts or pricing advice. Duplicate payment lists show possible duplicates for your review; nothing is confirmed, removed, or reversed, and no fraud finding is made. Expiry reports do not send reminders or renew anything.