Language:


Entering a Cash Transaction - Payments Card

You can use the 'Payments' card of a Cash In or Cash Out record to pay off Sales and Purchase Invoices, providing the payments are made in cash. You can also pay Personnel Payments, Credit and Debit Notes and Prepayments, and reverse Cash In or Cash Out records.

Invoices and Purchase Invoices paid off in this manner will no longer be treated as open, but records in the Receipt or Payment registers will not be created.

As you add rows to the 'Payments' card, the Total and Net fields on the 'Amounts' card will be updated automatically.

Type
Paste Special    Choices of possible entries
Use this field to specify the type of cash transaction. You can mix Types in a single record, providing all cash payments use the same Customer/Supplier, Person and Objects.

These are the choices available in a Cash In record:
Cash In
Use this option to record a standard cash receipt. Enter the value of the cash receipt in the Sum field.

The resulting Nominal Ledger Transaction will debit the Account from the Payment Mode and credit the Account from the Corresponding Mode. If you have several rows with this Type, the Transaction will contain separate credit postings for each row.

If you are using the Post VAT option in the Cash Book Settings setting, you cannot use the "Cash In" option here. Instead, you should enter the entire value of the cash receipt to the Total field on the 'Amounts' card and leave the grid on the 'Payments' card empty.

Invoice
Use this option to record a cash receipt against an existing outstanding Invoice. When you enter the Invoice Number in the Number field to the right (using 'Paste Special'), the Customer will be placed in the Company field, and the outstanding amount will be placed in the Sum field. The Customer and Address will also be placed in the appropriate fields on the 'Amounts' card. You can change the Sum if necessary.

You can enter several Invoices in a single Cash In record, but they must all use the same Customer. If the Customer Number and outstanding amount are not placed in the Company and Sum fields when you enter an Invoice Number, this will be because the Customer is different to the one on the row above, or to the one already entered on the 'Amounts' card.

The resulting Nominal Ledger Transaction will debit the Account from the Payment Mode and credit the Debtor Account from the Invoice. If you have several rows with this Type, the Transaction will contain separate credit postings for each row. If you are using the Post Receipt VAT option in the Account Usage S/L setting, the VAT value will be debited from the Output Account and credited to the O/P or VAT (C/A) Account. The VAT value will be calculated using the VAT Code on the first row of the Invoice. This VAT Code will be visible on the 'Amounts' card. If you are receiving cash against several Invoices in one Cash In, the VAT Code will be taken from the last Invoice that you enter in the grid, so take care that this VAT Code is appropriate for them all.

The cash receipt will be included in the appropriate reports (e.g. the Sales Ledger report, the Periodic Customer Statement and the Open Invoice Customer Statement).

Credit Purchase Invoice
Use this option to record a cash receipt against an existing outstanding Purchase Credit Note (a "debit note"). This might be useful when you have paid a Purchase Invoice and you then receive a debit note and a cash refund. When you enter the Number of the original Purchase Invoice (i.e. not the Number of the debit note) in the Number field to the right (using 'Paste Special'), the Supplier will be placed in the Company field, and the outstanding amount will be placed in the Sum field. The Supplier and Address will also be placed in the appropriate fields on the 'Amounts' card. You can change the Sum if necessary. If you are using the Post Payment VAT option in the Account Usage P/L setting, the VAT value will be debited from the Input Account and credited to the I/P or Prepayment VAT Account. The VAT value will be calculated using the VAT Code on the first row of the Purchase Invoice. This VAT Code will be visible on the 'Amounts' card. If you are receiving cash refunds against several Purchase Invoices in one Cash In, the VAT Code will be taken from the last Purchase Invoice that you enter in the grid, so take care that this VAT Code is appropriate for them all.

You can enter several Invoices in a single Cash In record, but they must all use the same Supplier. If the Supplier Number and outstanding amount are not placed in the Company and Sum fields when you enter an Invoice Number, this will be because the Supplier is different to the one on the row above, or to the one already entered on the 'Amounts' card.

The resulting Nominal Ledger Transaction will debit the Account from the Payment Mode and credit the Creditor Account from the Purchase Invoice. If you have several rows with this Type, the Transaction will contain separate credit postings for each row.

The cash receipt will be included in the appropriate reports (e.g. the Purchase Ledger report, the Periodic Supplier Statement and the Open Invoice Supplier Statement).

Personnel Payment
Use this option to record a cash receipt from a member of staff. Enter the value of the cash receipt in the Sum field. You must enter a Person on the 'Amounts' card before you can save the Cash In record.

The resulting Nominal Ledger Transaction will debit the Account from the Payment Mode and credit the Account from the Person record ('Bonus' card).

The cash receipt will be included in the Periodic Personnel Statement report in the Expenses module.

Prepayment
Use this option to record the receiving of a cash deposit. You must also enter a Prepayment Number in the Number field, a Customer in the Company field, and the value of the deposit in the Sum field. The Prepayment Number can be a number of your own generation, the number allocated to the prepayment by the Customer or, preferably, the number of the Sales Order against which the deposit has been received. The Customer must be one whose On Account check box ('Terms' card) has been switched on.

It is not necessary to use a unique number as the Prepayment Number. This allows you to receive more than one deposit against an individual Sales Order. However, using a Prepayment Number more than once may make the Prepayment History report difficult to understand, and may make it difficult to link a particular Prepayment to an Invoice using the 'Connect to Prepayment' function. Therefore you may wish to use the Force Unique Prepayment Numbers option, on the 'Debtors' card of the Account Usage S/L setting. This will mean that once a Prepayment Number has been used in an approved Prepayment, you will not be able to use it again.

The resulting Nominal Ledger Transaction will debit the Account from the Payment Mode and credit the Debtors On Account A/C for the Customer Category to which the Customer belongs, or the On Account A/C on the 'Debtors' card of the Account Usage S/L setting. If you are using the Post Prepayment VAT option in the Account Usage S/L setting, the VAT value will be debited from the Prepayment VAT Account in the same setting and credited to the O/P or VAT (C/A) Account. The VAT value will be calculated using the VAT Code on the first row of the Order. This VAT Code will be visible on the 'Amounts' card. If you are receiving cash deposits against several Orders in one Cash In, the VAT Code will be taken from the last Order that you enter in the grid, so take care that this VAT Code is appropriate for them all.

When you raise an Invoice to be set against the Prepayment, you can connect the two using the 'Connect to Prepayment' function on the Operations menu of the Invoice screen. This is fully described on the On Account Receipts and Prepayments page. The Prepayment will be shown in the Prepayment History report in the Sales Ledger.

Reverse a Cash Out
Use this option to reverse a previous Cash Out record.
These are the choices available in a Cash Out record:
Cash Out
Use this option to record a standard cash payment. Enter the value of the cash payment in the Sum field.

The resulting Nominal Ledger Transaction will credit the Account from the Payment Mode and debit the Account from the Corresponding Mode. If you have several rows with this Type, the Transaction will contain separate debit postings for each row.

If you are using the Post VAT option in the Cash Book Settings setting, you cannot use the "Cash Out" option here. Instead, you should enter the entire value of the cash payment to the Total field on the 'Amounts' card and leave the grid on the 'Payments' card empty.

Credit Invoice
Use this option to issue a cash payment against an existing outstanding Credit Note. This might be useful when a Customer has paid an Invoice and you then issue a Credit Note and a cash refund. When you enter the Number of the original Invoice (i.e. not the Number of the Credit Note) in the Number field to the right (using 'Paste Special'), the Customer will be placed in the Company field, and the outstanding amount will be placed in the Sum field. The Customer and Address will also be placed in the appropriate fields on the 'Amounts' card. You can change the Sum if necessary.

You can enter several Invoices in a single Cash Out record, but they must all use the same Customer. If the Customer Number and outstanding amount are not placed in the Company and Sum fields when you enter an Invoice Number, this will be because the Customer is different to the one on the row above, or to the one already entered on the 'Amounts' card.

The resulting Nominal Ledger Transaction will credit the Account from the Payment Mode and debit the Debtor Account from the Invoice. If you have several rows with this Type, the Transaction will contain separate debit postings for each row.

The cash payment will be included in all appropriate reports (e.g. the Sales Ledger report, the Periodic Customer Statement and the Open Invoice Customer Statement).

If you need to post VAT from a cash refund, you cannot use the "Credit Invoice" option here. Instead, you should make sure you are using the Book Receipt VAT option in the Account Usage S/L setting and then enter the cash refund in the Receipt register in the Sales Ledger, using an appropriate Payment Mode.

Purchase Invoice
Use this option to record a cash payment against an existing outstanding Purchase Invoice. When you enter the Invoice Number in the Number field to the right (using 'Paste Special'), the Supplier will be placed in the Company field, and the outstanding amount will be placed in the Sum field. The Supplier and Address will also be placed in the appropriate fields on the 'Amounts' card. You can change the Sum if necessary.

You can enter several Purchase Invoices in a single Cash In record, but they must all use the same Supplier. If the Supplier Number and outstanding amount are not placed in the Company and Sum fields when you enter an Invoice Number, this will be because the Supplier is different to the one on the row above, or to the one already entered on the $MAILLNK(HW0402CASH_Entering_Amounts_Card,'Amounts') card.

The resulting Nominal Ledger Transaction will credit the Account from the Payment Mode and debit the Creditor Account from the Invoice. If you have several rows with this Type, the Transaction will contain separate debit postings for each row.

The cash payment will be included in all appropriate reports (e.g. the Purchase Ledger report, the Periodic Supplier Statement and the Open Supplier Customer Statement).

If you need to post VAT from a cash payment, you cannot use the "Purchase Invoice" option here. Instead, you should first make sure you are using the Book Payment VAT option in the Account Usage P/L setting and then enter the cash payment in the Payment register in the Purchase Ledger, using an appropriate Payment Mode.

Personnel Payment
Use this option to record a cash payment made to a member of staff. Enter the value of the cash payment in the Sum field. You must enter a Person on the 'Amounts' card before you can save the Cash Out record.

The resulting Nominal Ledger Transaction will credit the Account from the Payment Mode and debit the Account from the Person record ('Bonus' card).

The cash payment will be included in the Periodic Personnel Statement report in the Expenses module.

Prepayment
Use this option to record the issuing of a cash deposit. You must also enter a Prepayment Number in the Number field, a Supplier in the Company field, and the value of the deposit in the Sum field. The Prepayment Number can be a number of your own generation, the number allocated to the prepayment by the Customer or, preferably, the number of the Purchase Order against which the deposit is being issued. The Supplier must be one whose On Account check box ('Terms' card) has been switched on.

It is not necessary to use a unique number as the Prepayment Number. This allows you to issue more than one deposit against an individual Purchase Order. However, using a Prepayment Number more than once may make the Prepayment History report difficult to understand, and may make it difficult to link a particular Prepayment to a Purchase Invoice using the 'Connect to Prepayment' function. Therefore you may wish to use the Force Unique Prepayment Numbers option, on the 'Creditors' card of the Account Usage P/L setting. This will mean that once a Prepayment Number has been used in an approved Prepayment, you will not be able to use it again.

The resulting Nominal Ledger Transaction will credit the Account from the Payment Mode and debit the Creditors On Account A/C in the Customer record for the Supplier ('Accounts' card), the Creditors On Account A/C in the Customer Category to which the Supplier belongs, or the On Account A/C on the 'Creditors' card of the Account Usage P/L setting.

When you create a Purchase Invoice to be set against the Prepayment, you can connect the two using the 'Connect to Prepayment' function on the Operations menu of the Invoice screen. This is fully described on the On Account Payments and Prepayments page. The Prepayment will be shown in the Prepayment History report in the Purchase Ledger.

If you need to post VAT from a cash deposit, you cannot use the "Prepayment" option here. Instead, you should first make sure you are using the Book Prepayment VAT option in the Account Usage P/L setting and then enter the cash receipt in the Payment register in the Purchase Ledger using an appropriate Payment Mode.

Reverse a Cash In
Use this option to reverse a previous Cash In record.
The 'Paste Special' list attached to the Number field will vary, depending on what you have entered here.

Number
Paste Special    Open, approved Purchase or Sales Invoices
If the Type (above) is Invoice or Credit Purchase Invoice (in a Cash In record), or Purchase Invoice or Credit Invoice (in a Cash Out record), enter the Sales or Purchase Invoice Number of the Invoice to be paid off. When you press the Tab or Enter key, its Customer or Supplier Number will appear in the Company field, and the outstanding amount will be placed in the Sum field.

You can enter several Invoices in a single cash transaction, but they must all use the same Customer or Supplier. If the Customer or Supplier Number and outstanding amount are not placed in the Company and Sum fields when you enter an Invoice Number, this will be because the Customer or Supplier is different to the one on the row above, or to the one already entered on the 'Amounts' card.

If the Type is Prepayment, you must enter a Prepayment Number here. This can be a number of your own generation, the number allocated to the prepayment by the Customer or Supplier or, preferably, the number of the Sales or Purchase Order against which the deposit has been received/issued. The Customer or Supplier must be one whose On Account check box ('Terms' card) has been switched on.

It is not necessary to use a unique number as the Prepayment Number. However, using a Prepayment Number more than once may make the Prepayment History report difficult to understand, and may make it difficult to link a particular Prepayment to an Invoice using the 'Connect to Prepayment' function. Therefore you may wish to use the Force Unique Prepayment Numbers option, on the 'Debtors' card of the Account Usage S/L setting (on the Cash In side), and on the 'Creditors' card of the Account Usage P/L setting (on the Cash Out side). This will mean that once a Prepayment Number has been used in an approved Prepayment, you will not be able to use it again.

Company
Once you have entered a Sales or Purchase Invoice to the Number field, its Customer or Supplier will be shown here. This can't be changed.

If the Type is Prepayment, you must specify the Customer from which the cash deposit was received or the Supplier to which it was issued.

Sum
Enter the value of the cash payment, including VAT if appropriate. As you add rows to the 'Payments' card, the Total and Net fields on the 'Amounts' card will be updated automatically.