Sundry Bank Payments

Entering your Sundry Bank Payments

Written By Niall Conlon (Draft Writer)

Updated at September 5th, 2022

Introduction

You can record Sundry Payments from your company’s Bank Accounts. These refer to one-off expenses rather than being for a Supplier (Vendor). Examples include salary, payroll, or tax liabilities.
 

Payments will be credited to the selected Bank Account and debited to a selected General Ledger Account. 


Delete

Info

We do not recommend entering bank charges through this option as they are not classed as payments. Instead, the Sundry Bank Payments screen allows you to access the Bank Credit Journal screen to process a bank charges transaction.

See:

Bank Receipts and Payments (6A.3) - AIQ Academy

Delete

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.

Delete

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.

 

Graphical user interface, text, application

Description automatically generated

 

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 assigned to each new line in the batch. It saves you from recording the date each time you complete a line. You can override this at any point before processing a batch.
  • Payment Reference: This field is only available if you are entering payments. You can use it to group payments by payment reference meaning the reference will appear as one line on your Bank Reconciliation for all related payments.
  • 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: Select the reference field you want to use for calculating the net, tax, and gross values. 
    If you select ‘Gross Amount’, and when processing a bank payment enter the gross amount and then a tax rate, then 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. As you will enter the gross amount in most cases for bank payments, the calculation reference defaults to' Gross Amount' on these screens.

Line Details

Complete the following Line details:

  • 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.
  • Print Batch: Click to print the contents of the grid.

 

Completing and Processing the Batch Payments 

  1. Once you have finished entering lines, click Process. This creates the associated bank payment transactions (BP). 
  2. 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‍ 

Delete