Introduction
The Sundry Bank Payments facility lets you record Sundry Payments made from your bank accounts. Sundry Payments are payments that are not made to suppliers set up in the system. This could include asset purchases, expenses, etc These payments are credited to the relevant GL bank account and debited to a selected GL Code.
See:
Bank Receipts and Payments (6A.3) - AIQ Academy
Accessing Sundry Bank Payments
You can access Sundry Bank Payments in three ways:
Option 1: Blue banner
From the blue banner, go to Bank > Sundry Bank Payments.
Option 2: Bank List grid
Go to Bank > Bank List. Find your account in the grid. Under Account Code & Name, click Payments.
Option 3: Using Actions
Go to Bank > Bank List. Find your account in the grid. Under Actions, select Sundry Payments.
Creating a Sundry Bank Payment
Navigating the Sundry Bank Payment screen
You can record as many lines in a batch as needed. If you close the screen with data entered, it will be saved and then display the next time you enter the screen.
The account lookup field automatically drops down when the cursor enters the field. You can start typing the account code and the system will suggest matching account(s) as you type.
To allow for quick data entry you can use your keyboard to navigate the data grid:
- TAB: Advances to the next cell in the grid
- TAB + SHIFT: Goes back to the previous cell in the grid
- ENTER: Advances to the next cell in the grid
- F6: Use to make a copy of the current line and insert a new line with the same details. This is a useful function if you are creating payment records with similar details, such as recording several payments to the same General Ledger account but with different cheque references.
- F8: Use to delete the current line.
Batch Details
Note the following fields under Batch Details:
- Bank A/C: Select the Bank Account you want to make payments to from the dropdown list. This list shows the Bank's related General Ledger Account Code, the Bank Name, and its currency code. The currency code of the bank appears in brackets beside the selected account.
- Batch Date: This is the default date of the batch. This will default on each line in the grid. You can change the date per transaction as required.
- Payment Reference: Record a payment reference here. This will be applied to all transactions in the batch. It can be used to group all transactions under a single reference. This reference will be shown in the bank reconciliation screen when reconciling this bank account.
- Add Bank Charges: Click to open a Credit Bank Journal screen to record any Bank Charges associated with this Batch of Payments.
-
Calculation Based On: Specify the reference field to be used by the system when calculating the net, tax, and gross values on a line. It defaults to Gross Amount. You can change this option as you enter each line depending on which whether you are entering a gross or net of tax amount. The calculation behaviour will change accordingly.
For example, if the Gross Amount field is selected as the calculation reference, if you enter the gross amount and then select a tax rate, the net amount will be calculated by referencing the gross amount and the rate. In this case, the net amount field will be locked from editing. Similarly, if you manually change the tax amount value, the gross amount will remain static and the net amount will change based on the tax amount change. If you need to enter the net amount for a payment, change the reference field option and the net amount field will serve as the reference value when calculating the tax and gross amounts.
Line Details
You can record as many lines in a batch as you need. If you close the screen with data entered, it will be saved and available for you the next time the screen is opened.
- G/L A/C: Enter or select the General Ledger code which should be debited from the dropdown list. For example, if you are entering Employee Expenses you would select the General Ledger Account Code for expenses.
- BI Code: If you are using BI Codes, you can record a BI Code reference against each payment line. The transaction created will then have the department reference assigned to it and it will appear on related reports. It is mandatory to record a BI Code against the transaction if the General Ledger account that you have chosen has Use BI Code ticked in the General Ledger Master Record.
- Date: The transaction date on each line defaults to the batch date selected at the top of the screen. However, you can change it to any valid date. If you enter a date that is greater than the current General Ledger period, then the system will warn you that you are posting to a future period.
- Ext Ref/Cheque: This is the reference that will appear on your bank statement for reconciliation purposes, so it is important that it is meaningful. For payments, it is likely to be the cheque reference or any other payment identifier.
- Description/Payee: Enter a description of the payment for informational and tracking purposes. It will also appear on the Bank Reconciliation. This could be a more detailed reference or an identifying description. For example, if you are recording expenses, you could enter a description of the person to whom the expenses are being paid and the month/year of payment, such as "Exps. – Ritchie Blackmore – 07/11".
- Ex Rate: If you have selected a foreign currency bank, the exchange rate column will appear in the grid. This defaults from the currency rates table, but you can change this to the current exchange rate if required.
- Net: This is the net amount of the payment before any tax (if applicable). The system will calculate this if you enter the Gross Amount.
- Tax Code: If tax is applicable to this transaction, you can enter or select the relevant code here. If no tax applies, such as in the case of expenses, leave it blank. If you subsequently change the Net Amount, the system will then use this new Tax Rate to calculate the new Tax Amount.
- Tax Amt: Enter the tax amount applicable to the transaction. This is equal to (net x tax rate). Because there may be odd tax amounts associated with some direct payments, you can change this amount by entering an alternative amount. The system then calculates a new Tax Rate based on the input amount.
- Gross Amt: This is the sum of the Net Amount and the Tax Amount. If Tax is applicable, you can get the system to calculate the Net Amount, based on the applicable Tax Rate, by entering/changing the value displayed.
- Totals: The Gross total of all payments in the batch appears both at the top of the tab and the bottom of the grid.
- Clear Batch: Click to clear the grid and delete all lines. Use this option if you wish to cancel an existing batch and start again.
- Export: Export a CSV file containing the current contents of the grid.
Completing and Processing the Batch Payments
- Once you have finished entering lines, click Process Batch. This creates the associated bank payment transactions (BP).
- After creating the batch, a link appears at the bottom of the page where you can view the newly created records. Clicking this link will open the Transactions Browser with the associated transactions shown. When you have returned to the bank listing window you will notice that the bank balance has been reduced by the total value of the payments recorded (if they are not future dated).
See:
Bank Credit and Debit Journals