What this does: Imports the journal entry file you exported from ChamberMaster into QuickBooks Desktop.
Applies to: ChamberMaster and MemberZone, with QuickBooks Desktop. For QuickBooks Online, see QuickBooks Online Import.
Before you start:
- Export your journal entries from ChamberMaster and save the file. See Exporting Journal Entries for QuickBooks Desktop.
- You need the QuickBooks administrator login, and everyone else must be out of the company file.
Time needed: About 10–15 minutes, including the member name check.
Check for member name changes in ChamberMaster
QuickBooks matches each entry to a customer by name. If a member's name in ChamberMaster no longer matches the customer name in QuickBooks, QuickBooks creates a new customer. Run this check before every import.
- Click Reports in the left-hand rail.
- In the Report Finder, type Update in the Search by Keyword box and click Search.
-
Click Member Record Updates. The report opens as Member Update Activity.
- In the From and To fields, enter the same date range you used for your journal entry export.
-
In the Change Type list, select Member Company Name, then click the Refresh Listing button.
Checkpoint: The report lists every member whose company name changed in that date range, with the Old Value and New Value. If it shows no changes, skip to the next section.
- For each name in the report, open the matching customer in QuickBooks and update the customer name to match the New Value.
Sign in to QuickBooks as admin in single-user mode
QuickBooks only accepts the import from the administrator, and only while no one else is in the company file.
- Open QuickBooks and sign in as the administrator. In the user list, this user shows as Admin or as a username followed by (admin). If you haven't set up users in your company file, you're signed in as Admin by default.
- Ask anyone else working in the company file to close it or exit QuickBooks.
- Select File, then Switch to Single-user Mode. If the menu shows Switch to Multi-user Mode instead, you're already in single-user mode.
Import the journal entry file
The ChamberMaster export is an IIF file (Intuit Interchange Format, a file type QuickBooks Desktop can import).
- In QuickBooks, select File, then Utilities, then Import, then IIF Files.
- Find the file you exported from ChamberMaster, select it, and click Open. QuickBooks imports the file.
- To review the entries, select Company, then Make General Journal Entries.
Checkpoint: The new general journal entries appear in QuickBooks with the dates, accounts, and amounts from your ChamberMaster export.
Keep open invoice reports accurate
You can run all customer and receivable reports in ChamberMaster, including the Open Invoices report. If you also rely on the QuickBooks open invoice report, apply each imported payment journal entry to the matching open balance on the customer in QuickBooks. Otherwise, the QuickBooks report will still show those invoices as unpaid.
Common pitfalls
- Duplicate customers: A member renamed in ChamberMaster but not in QuickBooks becomes a new QuickBooks customer. Run the member name check before every import.
- New accounts appear in QuickBooks: If an account name in the file doesn't exist in QuickBooks, QuickBooks creates it. When you rename an account in your QuickBooks chart of accounts, rename it in ChamberMaster too.
- Import is blocked: QuickBooks won't import unless you're signed in as admin and in single-user mode.