Skip to content

QuickBooks Daily Return Import

Introduction

The QuickBooks Daily Return Import produces a report of the day's OPD billing and payment journal entries. When imported into QuickBooks Desktop, it creates the corresponding journal entries in the accounting system — one entry per bill or payment method, mapped to the configured QuickBooks accounts and classes.

Reports → Reports → QB Import Reports tab → 1. QB Import Reports

Producing the Daily Return

  1. Set From and To.
  2. Choose the Institution, Site and Department if you need to narrow the report.
  3. Click Process.
  4. Click Excel to download the result, or Print.

The rows are laid out for import into QuickBooks. Convert or import the downloaded file as your QuickBooks setup requires.

Importing into QuickBooks Desktop

  1. Open QuickBooks Desktop.
  2. Go to File → Utilities → Import → IIF Files.
  3. Browse to the file, converted to .iif format.
  4. Click Open. QuickBooks processes the file.
  5. Review the import summary for any errors.
  6. The journal entries appear in the QuickBooks transaction list.

QuickBooks Account Mapping

HMIS maps revenue categories to QuickBooks accounts as configured in the system:

HMIS Category QuickBooks Account (example)
OPD Consultation 4100 · OPD Revenue
Laboratory 4200 · Investigation Revenue
Pharmacy 4300 · Pharmacy Revenue
Cash received 1010 · Cash
Card received 1020 · Card Receivable
Credit billed 1200 · Debtors Control

Account mappings are configured by your system administrator in the QuickBooks integration settings.

Troubleshooting Import Errors

Error Cause Fix
"Account not found" ACCNT value in IIF doesn't match QB account name Update HMIS account mapping to match exact QB account name
"Class not found" QBCLASS not defined in QB Create the class in QuickBooks Classes list
Duplicate transaction File imported twice Check QB transaction log; delete duplicates if needed

Technical Reference

Item Detail
Controller QuickBookReportController
IIF entity QuickBookFormat
File format Tab-delimited IIF (TRNS/SPL/ENDTRNS)
Related QB Integration Overview