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 address

Benefits 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

User Avatar
Flag of AUSTRALIA

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,版权归原作者所有。

阅读原文 ↗

用 HomepageTab 新标签页关注 RSS,打开浏览器就能看到更新。

安装 HomepageTab