Zuora provides a standard Accounts Receivable by Accounting Code report that allows you to quickly and easily create summarized journal entries in order to enter your Zuora activity into your General Ledger (GL) accounting system. This article will focus on creating summarized GL entries. Please note that transferring individual transactions to QuickBooks will not be addressed in this article.
Zuora activity encompasses a number of transactions that need to be journalized. These activities include:
Note: Your business may not include all of these transactions within any given accounting period.
Go to Z-Billing > Reports > Accounts Receivable, and set the following values for the report Time Frame:
This report results will provide a summarized view of each Zuora transaction broken down by accounting code and currency.
Each column of the AR by Accounting Code Report corresponds to a specific transaction type as detailed in the following table:
| Report Column | Transactions |
|---|---|
| Invoice | Posted invoices. |
| Payment | Payments received for outstanding invoices. |
| Refund | All refunds for non-credit balance transactions. |
| Invoice Adjustment [Credit] | All invoice adjustments and invoice item adjustments that decrease the outstanding balance on an invoice. Note: The invoice adjustment transaction is deprecated on Production. Zuora recommends that you use the Invoice Item Adjustment transaction instead. |
| Invoice Adjustment [Charge] | All invoice adjustments and invoice item adjustments that increase the outstanding balance on an invoice. Note: The invoice adjustment transaction is deprecated on Production. Zuora recommends that you use the Invoice Item Adjustment transaction instead. |
| Credit Balance Increase [Payment] | All payments not applied to an invoice and all overpayments. Also referred to as a Credit Balance payment. |
| Credit Balance Decrease [Refund] | All refunds of overpayments and payments not applied to an invoice. Also referred to as a Credit Balance Refund and is the reversal of a Credit Balance Payment. |
| Credit Balance Increase [Invoice] | Transfers of negative invoice balances to credit balance. Also referred to as a Credit Balance Adjustment (Increase) because this operation would increase the credit balance amount on a customer account. |
| Credit Balance Decrease [Invoice] | Credit balance transfers to reduce the outstanding balance on an invoice. Also referred to as Credit Balance Adjustment (Decrease) because this operation would decrease the credit balance amount on a customer account. |
Each row corresponds to a specific accounting code.
Since each column represents a specific transaction, a single journal entry can be used to represent each column.
For example, consider the following table:
| Accounting Code | Invoice | Payment |
|---|---|---|
| (blank accounting code) | 41,447.61 | |
| Set Up Fees | 700,000.00 | |
| Services | 1,000,000.00 | |
| Bank-B2C | 1,004,804.50 | |
| Bank-B2B | 500,020.28 | |
| Totals | 1,741,447.61 | 1,504,824.78 |
This can be represented by the following two journal entries:
| Debit Account | Credit Account | Debit Amount | Credit Amount | |
|---|---|---|---|---|
| A/R | 1,741,447.61 | |||
| Unclassified Revenue | 41,447.61 | |||
| Set Up Fees | 700,000.00 | |||
| Services | 1,000,000.00 | |||
| To record all posted invoices for the period | ||||
| Bank-B2C | 1,004,804.50 | |||
| Bank-B2B | 500,020.28 | |||
| A/R | 1,504,824.78 | |||
| To record all payments made against outstanding invoices | ||||
The above journal entries are examples of how to record these transactions. Your own journal entries will vary based on your company's Chart of Accounts and accounting practices.
For specific instructions regarding creating journal entries in your accounting system, please refer to the documentation provided by your accounting software vendor.
If your company's business practices require that supporting documentation be provided for each entry, see How do I validate that the Zuora standard A/R Report is accurate?
There are several circumstances which should be considered when summarizing transactions:
