Account Register

An Account Register shows all the transactions related to a selected account, such as bank accounts, accounts receivable, accounts payable, and general ledger accounts. It provides a complete transaction history for the selected account, allowing users to review all debit and credit entries, monitor the running balance, and analyze account activity over a specified date range.

Field	Description
Amount	This field shows the amount of the transaction.
Amount (Home Currency)	This field shows the amount of the transaction in home currency.
Account	This field displays the account name associated with the transaction. To search for transactions belonging to multiple accounts, use the Advanced Search option, select the Account column, and enter multiple account names separated by the pipe (|) operator.
Account Number	This field displays the account number of the account associated with the transaction.
Account Type	This field displays the account type of the selected account, such as Bank, Fixed Asset, Inventory, Prepayment, etc.
Balance	This field allows you to view the running balance in the account.
Cheque#	If the payment was done by cheque, this field records the cheque number associated with this transaction.
Credit	This field displays the amount of money that is leaving an account or being paid out.
Currency	This is the currency of the transaction.
Debit	This field displays the amount of money that is coming into an account or being received.
Entity	This field captures the vendor, if applicable, that has received the payment.
Ex. Rate	If the payment has been made to a foreign entity, this field captures the exchange rate for the transaction.
Is Reconciled?	This field serves as a flag to specify whether the transaction has been reconciled or not.
Item	Any item associated with the transaction is captured in this field.
Last Modified By	This field shows the username of the user who made the most recent changes to the transaction.
Last Modified	This field displays the date and time of the most recent changes to the transaction.
Linked ref	This field displayed the reference number associated with the linked payment.
Memo	The field displays notes or any additional information related to the transaction.
Payee Display	This field displays the vendor to which the payment has been made.
Payment Type	This field displays the method using which the payment has been made.
Primary Account Type	This field displays the primary type of account to which the transaction is related.
Project	This field displays the project number associated with the transaction.
Qty	This field displays the quantity of the item for which the payment has been processed.
Ref#	This field shows the unique reference number or identifier associated with the transaction for easy tracking and reference purposes.
Ref2#	This field shows the additional reference number or identifier associated with the transaction for easy tracking and reference purposes.
Sales Rep	The sales representative associated with the transaction is recorded in this field.
Tax Code Id	This field specifies the tax code applicable to a specific tax transaction.
Tax Ref Id	This field specifies the unique identifier or reference number associated with a specific tax transaction.
Txn Num	This is the unique identifier for the transaction.
Txn Date	This field captures the date of the transaction.
Type	This field captures the type of the transaction.
Printed Cheque#	This field displays the printed cheque number associated with cheque-based payment transactions.

Viewing Account Transaction History

To view the transaction history for a specific account:

1. Navigate to Menu → Accounting → Account Register.

2. Select the required account from the Account dropdown (for example, account 54545).

3. Specify the From and To date range, if required. Click Refresh.

4. The system displays all transactions posted to the selected account during the specified period, along with details such as transaction date, type, reference number, debit, credit, and running balance.

If you need summarized account balances instead of individual transactions, use reports such as the AR Aging Summary (for outstanding receivables) or the Adjusted/Unadjusted Trial Balance (for General Ledger account balances).

FAQs

How can I view a list of payments made under a specific expense account?

You can use the Account Register to view a detailed list of transactions recorded against a specific expense account, including information about the entities or payees associated with each payment.

To view payments by expense account:

1. Navigate to Menu → Accounting → Account Register.

2. Select the required Expense Account.

3. Specify the desired Date Range.

4. Click Refresh.

The Account Register displays transaction-level details, including:

• Account

• Entity

• Payee Display

• Payment Type

• Transaction Type

• Reference Number

• Transaction Date

• Debit/Credit Amount

• Memo

The Entity and Payee Display fields help identify who was paid for each transaction associated with the selected expense account.

Viewing multiple expense accounts

If you want to review transactions for multiple expense accounts at the same time, use the Advanced Search option in the Account Register.

When specifying multiple accounts, separate the account names using the | (pipe) character.

Example:

Office Expense | Travel Expense | Utilities Expense

This allows you to retrieve transactions for multiple expense accounts in a single search.