Mapping Transactions for Easy Integration
To ensure smooth integration between transactions in CNS (Chamber Nation Software) and QuickBooks, we need to set up mappings that allow a direct and accurate transfer of data.
1. Mapping Transactions to CNS GL Accounts:
- Membership Invoices (New Member and Dues): GL accounts are assigned as a package. New member invoices go to a specific GL account, while renewal invoices are assigned to another. You can manage this mapping in Member Billing > Edit General Ledger Accounts > Select GL Accounts for Membership Invoices.
- Non-Dues Invoices: GL accounts are assigned on an invoice-by-invoice basis when they are entered.
- Event Registration Invoices: GL accounts are assigned at the event level during event creation or editing. You can set a default GL account for event registrations in CNS Config > QuickBooks Config.
- Each CNS GL account needs to be linked to a corresponding GL account and item (products/services) in QuickBooks. You can do this in Member Billing > Edit General Ledger Accounts.
- If you can't find an appropriate GL account or item, you can create it directly in QuickBooks.