Record debit card transactions

Some Of the nominals and ledgers used in this topic may be different to those in your chart of accounts.

Debit card transactions can be for payments your establishment / organisation have made using a debit card.

In IRIS Financials you can add a transaction to record the details of a debit card payment using a document input form. Once entered, the payment can then be reconciled against an existing or future document/transaction (such as a supplier invoice)

The document input form used to record the transaction depends on the purpose of the direct debit payment.

These options are available:

  • Purchase Payment document input form - used to record payments made to suppliers. For example, a payment for an item that was needed urgently, but the invoice has not been received yet.

  • Miscellaneous Payment document input form - used to record ad-hoc payments, such as one of purchases. For example, for supplies for the staff room purchased from the local shop or an online purchase.

  • Petty Cash Reimbursement document input form - used to top-up the balance of a single petty cash tin to replace the cash used. Using this input form allows you to top-up the applicable petty cash tin over the imprest amount, if you have one (not recommended). For more information, see Recording Petty Cash Payments.

  • Multi Petty Cash Reimbursement document input form - used to top-up the balance of multiple petty cash tins to replace the cash used. Using this input form allows you to top-up the applicable petty cash tins over the imprest amount, if you have one (not recommended). For more information, see Recording Petty Cash Payments.

Recording debit card transactions consists of the following:

Selecting the Required Payment Document Input Form

Recording the Payment

Select the required payment document input form

  1. Select Documents, then select Document Input from the menu.

  2. The Document Input dialog opens. To select the document type, select Drill (...) in Document type. Double-select to select ASCD - Debit Cards (where AS represents the location code of the document type) from the Select a document type dialog. This selection filters the list of document input forms available in the next step.

  3. Next, select Drill (...) in Input form to select the document input form required for the type of payment you are recording. Double-select to select required input form from the Select an input form dialog. In this example, you select Purchase Payment.

  4. The Date defaults to the date that you are entering the information, that is, today's date. The date must be the same date as the date the payment was made using the debit card. To change the date, select the Date list arrow and select the required date from the calendar. Alternatively you can, select the up-down buttons, or overwrite the date using a DD Month YYYY format, for example, 27 January 2021.

  5. The Period defaults to the current accounting period. The document period must be the accounting period in which you made the payment. If the required accounting period is now closed and no longer available, select the next open accounting period by selecting Drill (...) in Period, then double-select to select the required period from the Select a period dialog.

  6. Select OK to confirm your selections. The applicable document input form then appears.

Record the payment

The previously selected document input form opens, populated with the details entered in the Document Input dialog.

Follow the instructions for the applicable document input form:

Record a debit card payment for a supplier

  1. The Purchase Payment document input form opens populated with the details entered in the Document Input dialog.

  2. First, enter the details of the bank account from which you made the debit card payment. Double-select in Bank, then double-select to select the required bank account from the Select account dialog.
    You cannot move to the next field if you have not entered the required data.

  3. Next, select the supplier that received the debit card payment. Double-select in Account, then double-select to select the required supplier account from the Select PURCHASE account dialog.

  4. The Document Date defaults to the date entered in the Document Input dialog. The date must be the same as the date the payment was made using the debit card. If required, you can change the date by selecting the Document Date list arrow, then selecting the required date from the calendar.

  5. Enter the value of the debit card payment in Value. This amount must exactly match the amount that left the bank account.

  6. Enter a description to help identify the purpose of the debit card payment in Description.

  7. The Account Summary on the right-hand side of the form shows the Creditor Balance, the Document Balance, and the New Creditor Balance.
    If the Account Summary shows negative balances, it may mean that the supplier account is in credit or that there are invoices missing. Continue to record the payment, and check the supplier account as necessary.

  8. When all the required payment information has been entered, press F5 or select POST to post the payment.
    If you want to allocate the payment after posting, select ALLOCATE to enable the allocation function before selecting POST to display the Allocation window (Alternatively, press and hold Shift and press F5 when posting) For more information, see Allocating and Unallocating Documents.

  9. A blank document input form opens with the posted document displayed in Documents Posted. Enter the details for an extra debit card payment or select X to close the document input form.
    To check, edit, or cancel the posted transaction, select the link to the document from Documents Posted. For more information, see Document enquiry functions.

Record a miscellaneous debit card payment

  1. The Miscellaneous Payment document input form opens populated with the details entered in the Document Input dialog.

  2. First, enter the details of the bank account from which you made the debit card payment. Double-select in Bank, then double-select to select the required bank account from the Select account dialog.
    You cannot move to the next field if you have not entered the required data.

  3. The Document Date defaults to the date entered in the Document Input dialog. The date must be the same as the date the payment was made using the debit card. If required, you can change the date by selecting the Document Date list arrow, then selecting the required date from the calendar.

  4. Enter the value of the debit card payment in Amount. This amount must exactly match the amount that left the bank account.

  5. Enter a description to help identify the purpose of the debit card payment in Description.

  6. Next, add the item details for the payment. Double-select in Nominal, then double-select to select the required nominal from the Select a nominal dialog.

  7. Next, select the account to which the payment relates. Double-select in Account, then double-select to select the required account from the Select account dialog.

  8. Next, enter the total amount for the payment including VAT in Gross, for example, 50.00(do not enter currency symbols, such as £ or $)

  9. If there is no automatically populated VAT rate or the VAT rate populated is incorrect for the payment, select the applicable VAT rate for the payment. Double-select in VAT Rate, then double-select to select the required VAT rate from the Select VATRATES key dialog. The VAT £ and Net are then automatically populated.

  10. Enter a description to help identify the purpose of the payment in Description.
    If you need to provide a more detailed description for the payment, press and hold the Ctrl key and the F8 key. The Detail Line 1 Comment dialog opens
    . Enter the details you want to include in the item description, then select Date Stamp to add the user details, time, and date to your comment, then select OK to save your comment.

  11. If the payment relates to a supplier, enter the supplier VAT number in Supplier VAT Number.

  12. If the payment covers several items/payments (for example, a fuel payment and hotel costs for an expenses claim) you need to insert an extra payment row to the document input form for each item. To create a new item row, select into the blank space adjacent to Supplier VAT Number, then press the Tab key, or select INSERT ROW. Complete the details of the inserted payment row as per Steps 6 - 11.
    If you insert a payment row you do not need, select anywhere in the payment row, then select DELETE ROW.

    If the new inserted payment row is to be coded to the same nominal and account as the previous payment row, enter a Period (full stop .) in the column on the inserted payment row, then press the Tab key. The information in the previous payment row is copied to the inserted payment row.

  13. If the Amount and Gross Total do not match, the Gross Total Does Not Match Document Amount message appears in the bottom left-hand corner of the window. You are not able to post the payment until this has been corrected.

  14. To correct the error, check that the Gross Total is the same as the amount in Amount. If these are different, make sure you have entered the correct individual amounts and all items of the payment. Also check that you selected the correct VAT rate. When the Gross Total and Amount equal the same amount, the Gross Total Does Not Match Document Amount message is removed.

  15. When all the required payment information has been entered, press F5 or select POST to post the payment.
    If you want to allocate the payment after posting, select ALLOCATE to enable the allocation function before selecting POST to display the Allocation window (Alternatively, press and hold Shift and press F5 when posting). For more information, see Allocating and Unallocating Documents.

  16. A blank document input form opens, with the posted document displayed in Documents Posted. Enter the details for an extra debit card payment or select X to close the document input form.
    To check, edit, or cancel the posted transaction, select the link to the document from Documents Posted. For more information, see Document enquiry functions.

Also see:

  1. Recording Petty Cash Transactions
  2. Allocating and Unallocating Documents
  3. Process prepayments
  4. Document enquiry functions