Record credit card expenditure

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

The Credit Card ledger holds the amount owed to the credit card company on the balance sheet as a liability until you make the payment. The individual credit card expenses need to be recorded. You can enter these individually, or enter them all when the credit card statement arrives.

When you have transactions for expenditure on a credit card, you need to record the payment to the credit card company that appears on the bank statement.

In IRIS Financials you can add a transaction to record the details of a credit 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, credit note, and so on)

Recording credit card transactions consists of these steps:

  1. Select the required payment document input form

  2. Record the payment

  3. Check credit card balances

Select the required payment document input form

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

  2. The Document Input dialog opens. Select Drill (...) in Document type, then double-click ASCC - Credit 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, to select the document input form required for the type of payment you are recording select Drill (...) in Input form, then double-click Credit Card Expense from the Select an input form dialog.

  4. The Date defaults to the date that you are entering the information, that is, today's date. The date must be the same as the date you made the payment using the credit 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, 22 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. Double-click 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

  1. The Credit Card Expense document input form opens populated with the details entered in the Document Input dialog.

  2. Firstly, enter the details of the credit card used to make the payment. Double-click Credit Card , then double-click the required credit card from the Select account dialog.
    On the Credit Card Expense document input form, you can enter the details for multiple transactions made on the credit card, however the transactions recorded must all be for the same card. If transactions relate to another credit card, then a separate Credit Card Expense document input form must be completed for that credit card.You are not able to move to the next field if the required data has not be entered.

  3. The Document Date defaults to the date entered in the Document Input dialog. The date must be the same as the date you made the expense payment on the credit 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 a description to help identify the purpose of the credit card payment in Description. In this example, Staff Room Supplies, has been entered.

  5. Enter the value of the credit card transaction in Document Control. This amount must exactly match the amount that of the credit card expense on the statement. In this example, the amount is 500.00 (do not enter any currency symbols, that is, £, $, and so on)

  6. Next, add the item details for the payment. Double-click Nominal, then double-click the required nominal from the Select a nominal dialog.
    If recording the payment of a supplier invoice by credit card, select the
    purchase ledger control nominal (9500) and the relevant supplier account (step 7). VAT on the transaction is on the supplier invoice, so you do not need to select it (step 9).

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

  8. Next, enter the total amount for the payment in Gross Value, for example, 200.00 (do not enter any currency symbols, that is, £, $, and so on)
    If the credit card expense is inclusive of VAT then the amount entered in Gross Value should be excluding VAT. The system calculates the Net value automatically when you select the applicable VAT Rate.

  9. To select the applicable VAT rate for the payment, double-click VAT Rate, then double-click the required VAT rate from the Select VATRATES key dialog.

  10. Enter a description to help identify the purpose of the credit card expense in Description, for example, Staff Kitchen Supplies.
    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, as this graphic shows. 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 this payment relates to a supplier, for example, a supplier invoice, enter the supplier VAT number in Supplier VAT Number.

  12. If the payment covers several items/payments (for example, staff kitchen supplies and a catered lunch) you need to insert an extra payment row to the document input form for each item. To create a new item line, select into the blank space next to Supplier VAT Number, then press the Tab key, or select INSERT ROW. Complete the details of the inserted payment row as described in steps 6 - 12.
    If you insert a payment row that you do not need, select anywhere in the 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 Document Control and Gross Total do not match, the Gross Total Does Not Match Document Control message appears in red 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 Document Control. If they are different, make sure that you 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 Document Control are the same amount, the Gross Total Does Not Match Document Control message disappears.

  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, as displayed in this graphic, to display the Allocation window (Alternatively, press and hold Shift, and press F5 when posting). For more information, refer to 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 credit card or select X to close the document input form.
    To open, edit, or cancel the posted transaction, select the link to the document in Documents Posted. For more information, refer to Document enquiry functions.

Check credit card balances

The balance relating to all credit cards is in the 9410 - Credit Card Control nominal. It is possible to view outstanding balances relating to credit cards by searching on the Credit Card Control nominal in the Trial Balance and Ledger List reports. For more information, refer to Run a trial balance or Producing a Ledger List.