Check report basis before comparing property software with QuickBooks

Check the accounting basis on both reports before deciding that a difference between property software and QuickBooks is an error. Even when the entity, property and date range match, cash and accrual views can present different amounts. Keep the original reports, establish the intended comparison with your accountant and investigate the difference using transaction support.

This is a reporting diagnostic for the agreed business books. It is not trust-account three-way reconciliation or advice to change an accounting method for tax purposes.

Same dates do not necessarily mean the same measurement

A report’s basis describes how it presents activity. Intuit explains that QuickBooks cash and accrual reports handle unpaid invoices and bills differently, and that an individual report can be viewed on a different basis. A report setting and a company’s accounting policy are separate decisions.

AppFolio offers several financial reports, including owner statements and income statements. Their names alone do not prove that their totals are directly comparable with a QuickBooks report. Check the actual report’s purpose, settings, entity and included activity using the access you are authorized to use.

Record a comparison header

Before working through amounts, write down the report name, business entity, property selection, period, accounting basis and generation time for each side. Record an unknown basis as unknown. Do not infer it from which total is closer to the bank.

Ask the accountant which two views should be compared. A distribution to an owner, a property’s operating result and management-company revenue describe different things. Changing a basis setting cannot repair a mismatch between those populations.

Example: one unpaid operating bill

Illustrative scenario. For a single owner-operated rental business, assume the accountant has already classified a $2,400 maintenance bill as an operating expense for the period. The bill is entered, remains unpaid at month-end and is the only difference under review. Exclude deposits held for others, taxes, prepayments, inventory and other adjustments from this simplified example.

The accrual expense view includes the $2,400 bill. A cash expense view does not include that unpaid bill in the same period. The bank has no payment for it yet. Those three observations can be consistent; a missing bank payment does not, by itself, mean the bill should be deleted.

Record the bill reference beside the $2,400 difference. If the accountant confirms that aligned report views now agree, document that finding. Do not post a $2,400 balancing entry simply to make unlike reports match.

The example isolates one reporting difference. Real reports can contain additional transactions and settings, so it is not a promise that toggling the basis will explain every discrepancy.

Use a controlled diagnostic copy

Save the reports used in the original comparison. Where your permissions and workflow allow, generate a separate diagnostic view using the agreed basis and retain its settings. Leave company-wide preferences unchanged unless an authorized accounting decision calls for a change.

Then trace the specific difference to bills, receipts or other supporting entries. A changed total without an explanation is not a completed reconciliation. If the reports still differ, investigate the remaining items separately instead of repeating setting changes until a number happens to agree.

Hand over an explanation, not just matching totals

The reviewer needs the original difference, report settings, transaction references, diagnostic result and unresolved questions. Identify which report is intended for the final reporting package. Keep the explanatory note beside the exports so a later rerun can be understood.

If the dates themselves differ, use the cut-off checklist first. If the problem is how operational records should relate to business books, review DaxSync’s software and QuickBooks reconciliation scope. We work through an agreed bookkeeping process; this does not imply an automatic integration between platforms.