Audit Accounting Spreadsheet Formulas
$10-30 USD
Posted 1 minute ago
•
Ends in 6 days
$10-30 USD
Paid on delivery
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.
Project ID: 40829522
About the project
5 proposals
Open for bidding
Remote project
Active 5 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
5 freelancers are bidding on average $18 USD for this job


A SUM range that stops one row short, or a subtotal typed over a formula, skews a roll-up without any error showing, so I'd check those two first. I'd read every formula in both tabs by script, compare each subtotal and the location count to the raw rows, and log every change on its own sheet. Reconciling output against source rows is routine from my Node pipeline that generates nearly 300 apps from data files. The price covers the income and expense tabs only; anything more I'd quote first. Do the tabs pull from a separate locations list, or is each location typed in?
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗