Automated Fixed Asset Reconciliation
When a KBKG study is completed, WebRun reads its asset classifications and recovery periods, opens the fixed asset ledger in QuickBooks, matches each line, and writes a Google Sheet variance report listing every difference in class, recovery period, or amount for a preparer to resolve.
How do I reconcile cost segregation asset classes to the fixed asset ledger?
When a KBKG study is completed, WebRun reads its asset classes and recovery periods, opens the matching fixed asset ledger in QuickBooks, pairs each line, and writes a Google Sheet variance report listing every difference in class, recovery period, or amount, with the dollar impact totaled by bucket for a preparer to resolve.
- Every completed study is checked against the books, line by line
- Class and recovery period mismatches are caught before the return is filed
- Reallocated basis is totaled by bucket, so the net impact is clear at a glance
Built for cost segregation firms · CPA firms · tax preparers · accounting teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
kbkg.comin a real browser with your saved login - no setup, no API keys. -
1
KBKG - read the study classifications
kbkg.com
WebRun opens KBKG to read the study classifications. - Open the completed study in KBKG
- Read each asset line with its class life, recovery period, and reallocated amount
- Group the lines into 5, 7, 15, and 39 year buckets
Done when Every classified asset line is read from the KBKG study.
-
2
QuickBooks - match the fixed asset ledger
- Open the fixed asset ledger for the property in QuickBooks
- Read each existing asset with its recovery period and cost basis
- Match the ledger lines to the study lines, item by item, without editing anything
Done when Each ledger line is matched, or marked unmatched, against the study.
-
3
Google Sheets - report every variance
google.com
WebRun opens Google Sheets to report every variance. - Open a variance report in Google Sheets
- List every mismatch in class, recovery period, or amount side by side
- Total the reallocated basis by bucket so a preparer can see the net effect
Done when The variance report shows every difference with its dollar impact.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it edit the ledger in QuickBooks?
No. WebRun only reads the fixed asset ledger to compare it against the study. Every difference goes into a variance report for a preparer to review and post. Nothing in the books is changed on its own.
What counts as a variance?
A variance is any line where the class, recovery period, or amount in the KBKG study differs from the matching asset in QuickBooks, including study lines with no ledger entry yet and ledger lines the study did not reallocate.
How are the two sides matched?
WebRun matches by property and asset description, then by cost basis, and lists anything it cannot pair as unmatched so a preparer can decide rather than forcing a guess.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.