Audit Accounting Spreadsheet Formulas
Budget / Salary$10–30
TypeFreelance project
LocationRemote
Posted2 hours ago
My accounting spreadsheet is out of balance—374 locations should roll up cleanly, yet the figures in the income and expense tabs refuse to agree. I need someone to dig into those two sections only, trace every formula, and correct or flag anything that keeps the totals from reconciling.
Here’s what I expect:
• Inspect every cell-level formula in the income and expense sheets, checking ranges, references, and consistency.
• Fix or clearly comment on any #REF!, #VALUE!, circular references, or hard-typed numbers that should be dynamic.
• Recalculate the workbook so the location count and all subtotals match the underlying data.
• Leave a short change log or in-sheet notes so I can see exactly what was adjusted.
The file is in Excel; I can share a Google Sheets copy if that speeds your review. Once the corrections are in place and the 374 locations reconcile properly, the task is done. A quick turnaround—ideally within 48 hours—would be perfect.
Here’s what I expect:
• Inspect every cell-level formula in the income and expense sheets, checking ranges, references, and consistency.
• Fix or clearly comment on any #REF!, #VALUE!, circular references, or hard-typed numbers that should be dynamic.
• Recalculate the workbook so the location count and all subtotals match the underlying data.
• Leave a short change log or in-sheet notes so I can see exactly what was adjusted.
The file is in Excel; I can share a Google Sheets copy if that speeds your review. Once the corrections are in place and the 374 locations reconcile properly, the task is done. A quick turnaround—ideally within 48 hours—would be perfect.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.