Property management guide

Document a property-software transaction missing from QuickBooks

Build a missing-record packet before adding or matching a transaction so an operational event is not duplicated in the accounting file.

When a transaction appears in property software but not in QuickBooks, do not start by recreating it. First prepare a missing-record packet that identifies the operational event, the expected QuickBooks representation, the bank evidence if relevant, and every alternate route by which it might already have reached the books.

Make the packet

Include the operational report name, generated time, entity, property or listing ID, source transaction ID, amount, date, report basis, expected QuickBooks account or workflow, and reviewer. Attach the bank reference only when the event should have a bank leg in the defined scope.

AppFolio describes accounting reports and export capability for property-management teams.1 The actual reports, permissions and setup vary. The packet records the report that was actually used; it does not promise a DaxSync integration.

Use four dispositions

Finding Next action
Already represented Link the QuickBooks transaction and close the packet.
Pending through another workflow Record the expected batch or date and keep it open.
Supported missing record Send the documented packet for the approved posting workflow.
Insufficient or conflicting evidence Add it to the exception log; do not create a balancing item.

Illustrative example. An operational report shows a $2,860 maintenance charge for Property 18. A QuickBooks search finds no vendor bill, but the bank feed shows a $2,860 debit that has not been reviewed. The packet links the source transaction, property ID and bank line. The correct next step may be an approved match or posting workflow after the reviewer confirms the documents; it is not to add a second $2,860 expense.

Check alternate routes before posting

Search by amount, vendor, date range, property ID and batch reference. Look for a prior export, manual entry, clearing record, bank-feed item or journal process. Intuit provides current guidance for duplicate bank-feed transactions; preserve the references before changing anything.2

Keep the packet with the mapping register and add unresolved cases to the reconciliation exception log. This is a managed reconciliation control. It does not make decisions about tax treatment, trust-account requirements, or what an owner should be charged.

Footnotes

  1. AppFolio accounting and reporting.

  2. Intuit: fix duplicate bank-feed transactions.

Sources and further reading

Source links provide background. The workflow and illustrative examples above are original educational material.

Our resource guides are prepared with AI assistance. Worked examples are illustrative unless explicitly identified otherwise. This guide does not interpret tax law, payroll law, or state trust-account requirements. Read our editorial standards.

Keep the systems. Connect the books.

Let’s talk about your property software, QuickBooks and the financial reports your business needs.

Book a call
DaxSync

Discovery call

Let’s connect your software and books.

Choose a time to discuss your operational software, QuickBooks and the reports your team needs.

45 minutes · Video call

  • Your software and current accounting handoff
  • The records, differences and reports involved
  • The scope and next steps

No documents needed to get started.

Appointments use our shared Daxable calendar. Your inquiry is for DaxSync.

Loading available times…

Having trouble? Open the calendar in a new tab ↗