Child pages
  • Recording, tracking and depositing payments

 

 

ANSWER ID:9080

This page explains how to record, track and deposit various customer payment types. This involves setting up a clearing account into which various payment types received through Customer Payments or Receive Money transactions can be allocated. A bank deposit can then be created allowing you to group payment types, cheque, cash, visa, etc. which can then be printed as a bank deposit slip.

For processing electronic payments, see the AccountEdge help (Australia | New Zealand).

 

1. Set up AccountEdge for customer payments
Before recording customer payments, you need to ensure the following have been setup:
  • undeposited funds account
  • payment methods, such as cash, cheque, EFTPOS, etc.
If your company file was set up using the default chart of accounts, an undeposited funds account may already exist. Also, your software comes with a set of default payment methods, although new payment methods can be created as required. 

An undeposited funds account exists to pool all received payments prior to those payments being cleared to the bank. Once an undeposited funds account is set up in your software, this account must be linked to ensure all received payments are allocated to the correct account.

If your software already has an undeposited funds account set up and this account has already been linked, skip to "Payment methods" below. 

Task 1 - Create an undeposited funds account

  1. Go to the Lists menu and choose Accounts.
  2. Click the Assets tab.
  3. Click New. The Account Information window appears.
  4. Select the Detail Account option.
  5. Set Account Type to Bank.
  6. Enter the Account Number and the Account Name, such as Undeposited Funds. The Edit Accounts window should look similar to the following example:
  7. Click the Details tab and set the Tax Code to N-T. If desired, enter an account Description.
  8. Click OK.

Task 2 - Link the undeposited funds account

  1. Go to the Setup menu and choose Linked Accounts then choose Accounts & Banking Accounts.
  2. In the Bank Account for Undeposited Funds Account field enter the Undeposited Funds account created above.
  3. Click OK.

Payment methods

To access the list of existing payment methods, go to the Lists menu and choose Sales and Purchases Information then choose Payment Methods.

The most common payment methods will already exist in your software. 

To create a new payment method:

  1. On the Sales and Purchases Information window shown above, click New

  2. Enter the Payment Method and set the Method Type as shown in the following example.

    The Payment Method can only contain letters and numbers - don't use special characters such as dashes, commas or asterisks. 
  3. Click OK.

To link a payment method to a customer's card to specify the method of payment for that customer:

  1. Go to the Card File command centre and click Cards List.
  2. Click the Customer tab.
  3. Click the zoom arrow next to the applicable customer.
  4. Click the Payment Details tab.
  5. Set the customer's Payment Method. Depending on the selection, a set of fields may be displayed for additional information, such as credit card details as shown below. 
     

  6. Click OK.
2. Record a customer payment

The steps below show how to record a customer payment, thus depositing their payment into the linked Undeposited Funds account.

  1. Go to the Sales command centre and click Receive Payments. Alternatively, a payment can also be recorded via the Banking command centre and clicking Receive Money.
  2. Select the Group with Undeposited Funds option at the top of the window.
  3. In the Customer field, click the dropdown arrow to select the customer who is making the payment.
  4. Enter the payment Amount.
  5. Select the applicable Payment Method.
  6. [Optional] Click Details and enter additional information relating to the payment method, such as credit card information.
  7. Enter the transaction details.
  8. Click Record.

The window below shows a Receive Payment customer payment that is to be grouped with the undeposited funds, and also has a Payment Method selected.

3. Prepare a bank deposit

Once there are multiple payments which have all been allocated to the linked Undeposited Funds Account, these funds can be cleared (deposited) to your bank account. This can be done for all received payments, or only for those received by specific methods, such as all cash and cheque deposits, or perhaps all credit card payments, etc. The steps below will transfer the customer receipts from the linked Undeposited Funds account to your software's General Bank account.

  1. Go to the Banking command centre and click Prepare Bank Deposit.
  2. In the Deposit to Account field, ensure the correct account is displayed and change if required. 

  3. Enter the Date and an applicable Memo for this deposit.
  4. Click the dropdown arrow next to the Select Receipts By field and select Payment Method. Note: If using the Deposit Adjustment feature to record items such as credit card merchant fees, you will need to set the Select Receipts By option to All Methods.
  5. Click the dropdown arrow next to the Payment Method field and select the Payment Methods to be deposited.
  6. Click OK to return to the Prepare Bank Deposit window where only payments received by the specified methods will be displayed.
  7. Select the payments to be included in the bank deposit.
  8. [Optional] Click Deposit Adjustment to enter and record credit card merchant fees.
  9. Click Record.

The window below shows 3 credit card transactions and 1 credit card merchant fee selected for the bank deposit.

The inclusion of a credit card merchant fee (-$9.54) was recorded through the Deposit Adjustment feature. This entry will only be displayed if the Select Receipts by field is set to All Methods.
4. Print a bank deposit slip

The Bank Deposit Slip report can be used for a bank deposit advice.

  1. Go to the Reports menu and choose Index to Reports.
  2. Click the Banking tab.
  3. Click the Bank Deposit Slip report (under the Cheques and Deposits sub-heading) then click Customise.
  4. Set the report parameters to display the applicable deposits then click Display.
  5. Click Print.

The window below shows an example Bank Deposit Slip report. It shows the bank account details and the total credit card payments that have been deposited.

  • Where a deposit includes more than one Payment Method, such as cash and cheques, the Payment Methods will be listed and totalled separately.
  • To automatically group all customer payments with your undeposited funds:
    • Go to the Setup menu and choose Preferences.
    • Click the Banking tab.
    • Select the option When I Receive Money, I Prefer To Group It With Other Undeposited Funds.
    • Click OK.
5. Delete or change a bank deposit

Once you create a bank deposit, the individual payments are "locked", so you'll need to delete the bank deposit before the individual payments can be modified. This also allows you to change the details of a bank deposit, such as a different date or to modify which payments are included in the deposit.

Here's how you do it:

  1. From any command centre, click Find Transactions.
  2. In the Find Transactions window, click the Accounts tab.
  3. In the Search by Account field, select your undeposited funds account.
  4. In the Dated From and To fields, specify a date range in which the bank deposit was first created.
  5. Find the bank deposit - this will be a credit and will generally have a "CR" number. See our example below where the bank deposit contains 3 individual payments
  6. Click the zoom arrow to open the deposit transaction.
  7. Go to the Edit menu and choose Delete Bank Deposit Transaction. The deposit will be deleted and the individual payment transactions will once again be listed on the Prepare Bank Deposit window.
  8. You can now delete or modify the individual payment transactions as required, then prepare the bank deposit again.