Account Registers

Account Registers let you view all transactions associated with a specific account for a selected date range, along with the opening and closing balances. You can use them to monitor payments, invoices, and journal entries under an account, verify entries, and maintain accurate records. In Zoho ERP, you can access account registers directly from the Chart of Accounts module.

Note: Account Registers aren’t supported for Stock and Inventory accounts.

Scenario: Patricia, an accountant at a retail company, wants to review all transactions posted to the Office Supplies expense account before closing the books for the quarter. She opens the account register for the Office Supplies expense account in Zoho ERP, filters by the current quarter, and reviews every transaction along with the opening and closing balances, all from a single page.

Access Account Registers

To access account registers:

Go to Accounting on the left sidebar.
Select Chart of Accounts in the module bar.
Select the account to access registers.
In the account’s pane, click Go to Registers in the top right corner.

Pro Tip: Hover over the required account, and click Go to Registers next to it.

In the next page, the list of transactions associated with that account will be displayed, along with the account’s opening and closing balances, for the selected date range.

In the next page, the list of transactions associated with that account will be displayed, along with the account’s opening and closing balances, for the selected date range. Click on a transaction to view it’s details. You can also edit or delete the transaction, based on your preferences.

To edit a transaction:

Click the More icon next to the required transaction, and select Edit from the dropdown.
In the pane that appears, make the required changes and click Save.

The transaction will be updated.

Similarly, to delete a transaction:

Click the More icon next to the required transaction, and select Edit from the dropdown.
In the confirmation pop-up, click Delete again.

The respective transaction will be deleted.

Pro Tip: To view account registers for your bank accounts, navigate to the Banking module under Accounting, and click Go to Registers next to the required account.

You can also view registers for your bank accounts. Here’s how:

Go to Accounting on the left sidebar.
Click Banking on the module bar, and select Banking from the dropdown.
Click the dropdown icon next to the required bank account, and select Go to Registers.

The registers for the bank account will be displayed.

Filter Account Registers

To filter the transactions displayed in the account register:

Go to Accounting on the left sidebar.
Select Chart of Accounts in the module bar.
Select the account for which you want to access account registers.
In the account’s pane, click Go to Registers in the top right corner.
In the next page, choose the desired filters:
- Date Range: Select a preset period to view transactions such as This Week, This Month, and more.
- Report Basis: Choose whether you want to filter transactions on the Accrual or Cash basis.
- Click + More Filters to apply additional filters like Transaction Type, Location, Projects, and more.
Click Run Report.

The register will display transactions based on the filters you applied.

Bulk Actions

Update Transactions in Bulk

You can update the accounts associated with multiple transactions at once. Here’s how:

Go to Accounting on the left sidebar.
Select Chart of Accounts in the module bar.
Select the account whose transactions you want to update.
In the account’s pane, click Go to Registers in the top right corner.
Select the transactions you want to update, and click Bulk Update at the top of the page.
In the Bulk Update Transactions pop-up, select the field you want to update, and enter the new value in the corresponding field.
Enter a reason to update the transactions.
Click Update.

The transactions will be updated. To view them:

In the account’s Details page, click the View Bulk Actions History icon in the top right corner.
In the Bulk Actions History pane, the list of actions performed will appear. Click View Details next to the update you want to view.

The list of updated transactions will appear.

Note: Some transactions cannot be updated in bulk. To update these, open each transaction individually, and make the required changes.

Delete Transactions in Bulk

To delete transactions associated with an account from the register:

Go to Accounting on the left sidebar.
Select Chart of Accounts in the module bar.
Select the account in which you want to delete transactions.
In the account’s pane, click Go to Registers in the top right corner.
Select the transactions you want to delete, and click Delete at the top of the page.
In the confirmation pop-up, click Delete to confirm.

The selected transactions will be deleted. To view them:

In the account’s Details page, click the View Bulk Actions History icon in the top right corner.
In the Bulk Actions History pane, the list of actions performed will appear. Click View Details next to the deletion you want to view.

The list of deleted transactions will appear.

Note: Some transactions cannot be delete in bulk. You must delete such transactions individually.

View Budgets

If you’ve added an account to a budget, you can view the budget details directly in that account’s register. Here’s how:

Go to Accounting on the left sidebar.
Select Chart of Accounts in the module bar.
Select the account for which you want to view the budget.
In the account’s pane, click Go to Registers in the top right corner.
Under Budgets, select the budget you want to view.

The register will display the account’s transactions for the selected budget period.

Once you select a budget, you can view a detailed breakup of the budget performance for the account. The following details will be displayed:

Budgeted Amount: The total amount allocated for the account in the selected budget period.
Actual Amount: The total amount recorded under the account during the budget period.
Over Budget: The amount by which the actual exceeds the budgeted amount, if applicable.

This helps you compare planned spending against actual transactions, making it easier to track and manage your finances within the budget period.

Create Journals

You can create a journal directly from the account’s register to record entries such as adjustments, corrections, or period-end entries. Here’s how:

Go to Accounting on the left sidebar.
Select Chart of Accounts in the module bar.
Select the account for which you want to create a journal.
In the account’s pane, click Go to Registers in the top right corner.
Click + New Journal in the top right corner.
In the New Journal pop-up, fill in the required details.
Click Save and Publish.

The journal will be recorded. You can also view this journal in the Manual Journals module.