Before payments to suppliers can be processed, payment types must first be defined so that payment funds are associated with their appropriate GL accounts. Payment types can also be set up for printed (and optionally pre-numbered) cheques and preauthorized payments (i.e., funds withdrawn automatically from specified bank accounts).
Payment types are set up for each location in your company. For example, one location may accept American Express and Visa, while another location may only accept Visa.
Each payment type and location requires a GL account for postings. If there is no GL account specified, the payment type is not available at that location. If your company has multiple locations, you can choose to use separate GL accounts for each payment type and location or choose to use the same GL account for all locations that have the same payments types.
Use the Manage AP Payment Types window to add, edit, deactivate, and delete the payment types that you can use to make payments to suppliers.
What you'll find:
You can add AP payment types that you can use to make payments to suppliers (e.g., Visa).
To add an AP payment type
* indicates
a required field
Navigate
to Accounts Payable > Manage
> AP Payment Types.
The Manage AP Payment Types window opens.
Click Add.
The Add AP Payment Type window opens.
In
the Description*
box, enter a unique description for the payment type.
For example, Cash.
This description appears anywhere that you select or view an AP payment
type and in all related reports.
Ensure the Active
box is checked.
Unchecking the box deactivates the payment type.
Select the payment Type*.
Cheque
You'll need to enter the following extra information for
each location offering that payment type in the GL
Accounts by Location table below.
In
the Print Cheque #? column, check boxes
for the locations that you want numbers printed on cheques.
If you use pre-numbered cheque stock,
clear the check box.
In
the Prefix Cheque No column, enter the
prefix that appears on all cheques before the cheque numbers for selected
locations.
Each location can have a different prefix.
In
the Next Cheque No column, enter the
first cheque number that you want to use for the next batch of cheques
for selected locations.
Each location can have a different start number (for example, you purchased
a batch of 1000 cheques; Edmonton gets cheques 1-500 and Calgary gets
cheques 501-1000).
However, cheque numbers must be unique per payment type (for example,
there can be only one Cheque #500 - there can't be an Edmonton Cheque
#500 and a Calgary Cheque #500).
Note
The Print Cheque #?, Prefix Cheque No, and Next Cheque No columns are only available if the payment type is Cheque.
EFT
Click Settings.
The Edit EFT Settings window opens.
Select a File Format*.
Tip
If a file format for your bank is not listed, you could try using CUPS (Credit Union Payment Services) and submitting to your bank.
The CUPS file format is used by the CAFT (Customer Automated Funds Transfer) Service – which is popular with prairie credit unions but also is used by other financial institutions. If your bank offers the CAFT Service then it will likely use CUPS as the file format.
If your bank follows the 1464 standard, try using the file formats for BMO or RBC.
If the test submission is not successful, your bank may give you feedback regarding errors that would be helpful for creating a new format.
Note
All File Formats assume that the Settlement Account for EFT transactions will be the same as the Funding/Main account (the bank account selected on the Add/Edit AP Payment Type window). may be required.
Enter
the following information provided by your bank:
Destination Data Centre*,
Originator ID*,
Short Name*,
Long Name*,
Next File Number*.
Depending on which File Format you selected,
you may be restricted from using special characters like "%"
or "!" or "#" in some fields.
Depending
on which File Format you selected, you
may also be required to fill in: (they will be flagged with an * if they are required)
Return Bank Number, Return
Branch Number, Return Account Number,
Trans. Routing Record (required
for RBC Express).
Select Single Payment Date if you want to limit EFT Payment Batches to a single date (or your bank requires it).
Check Lead Date Mandatory
(displayed only for the TD Canada Trust file format) if your bank
account requires lead time to process EFT payments.
For example most TD Canada Trust accounts require at
least 2 business days lead time, meaning if you make a payment
today the lead time date must be at least 2 business days from today,
allowing for weekends and bank holidays (which are different from
province to province). You'll indicate a specific Lead Date when adding
payments to an EFT
batch.
For the Currency Code* select CAD from the drop down list.
When
making EFT payments, the payment details are exported a file that
will be uploaded to your bank.
To select the File Path*,
click Browse.
The Browse for Folder window opens.
Select
a destination folder for the payment export file and click OK.
The Browse for Folder window closes.
Note
This folder must be on your local
hard drive or local area
network and be available outside
of agrē.
If more than one user will
be making EFT payments, it should be on a local
network drive that all users have access to outside of
agrē.
Update to save.
Other (this is the default)
e.g. Cash, Debit/Interac, VISA, FCC,
MasterCard. No extra settings required.
required for ALL payment types
In
the GL Account*
column, select a GL account for
each location that offers the payment type.
Payments are posted to the selected GL accounts.
Note
For locations that do not accept the payment type, leave the GL Account column blank.
Tip
Click Add Account to add a new GL account.
In
the Accrual Account column, select an
accrual account for each location
that offers the payment type (it's used for future dated payments).
Accrual accounts hold funds until the specified payment date (e.g.,
cheques); however, postings are made immediately. Your accrual account
should not be reconcilable, and it should be different than the GL
account that the payment postings are made to.
Click Save.
You can edit any of your existing AP payment types at any time.
To edit an AP payment type
Navigate
to Accounts Payable > Manage
> AP Payment Types.
The Manage AP Payment Types window opens.
In
the Payment Type list, select the payment type to edit and then click
Edit.
The Edit AP Payment Type window opens.
Edit the data, and/or add data to the payment type as needed.
Click Save.
An AP payment type can be deactivated if you no longer make payments of that type.
To deactivate an AP payment type
Navigate
to Accounts Payable > Manage
> AP Payment Types.
The Manage AP Payment Types window opens.
In the Payment Type list, select the payment type to deactivate and then click Edit.
Uncheck the Active check box.
Save the change.
The payment type is deactivated immediately.
If the payment type was specified as a supplier
default, it will be removed from the supplier account.
An AP payment type cannot be deleted if it has been or is being used on a supplier payment or account. Once you delete an AP payment type, it cannot be undone.
Note
If the Delete button is not available, the payment type you selected is in use and cannot be deleted. You may want to consider Deactivating it instead.
To delete an AP payment type
Navigate
to Accounts Payable > Manage
> AP Payment Types.
The Manage AP Payment Types window opens.
From the Payment Type list, select the payment type to delete and then click Delete.
Click
Yes to confirm the deletion.
The payment type is deleted.