Accounting Finance:Payment Proposals (EFTs) 2 - Revision history

Williamw at 16:39, 1 June 2021

2021-06-01T16:39:57Z

Williamw: /* Working with Payment Proposals */

2021-06-01T16:39:17Z

Working with Payment Proposals

Nancyn: Nancyn moved page Accounting Finance:A/P Transactions-Working with Payment Proposals (EFTs) to Accounting Finance:Payment Proposals (EFTs) 2

2018-02-23T18:27:59Z

Nancyn moved page Accounting Finance:A/P Transactions-Working with Payment Proposals (EFTs) to Accounting Finance:Payment Proposals (EFTs) 2

Chelseam at 15:49, 4 May 2017

2017-05-04T15:49:26Z

Chelseam at 23:33, 2 May 2017

2017-05-02T23:33:27Z

Chelseam: Chelseam moved page Finance:Expense Invoices-Printing Canada Post Invoice to Finance:A/P Transactions-Working with Payment Proposals (EFTs)

2017-05-02T21:54:54Z

Chelseam moved page Finance:Expense Invoices-Printing Canada Post Invoice to Finance:A/P Transactions-Working with Payment Proposals (EFTs)

Chelseam: Chelseam moved page Finance:Expense Invoices-Working with ITC Expense Invoices to Finance:Expense Invoices-Printing Canada Post Invoice

2017-05-02T21:19:45Z

Chelseam moved page Finance:Expense Invoices-Working with ITC Expense Invoices to Finance:Expense Invoices-Printing Canada Post Invoice

Chelseam: Created blank page

2017-05-02T21:16:21Z

Created blank page

New page

@@ Line 60: / Line 60: @@
 *If Monday is a holiday, on Friday run the payments until Friday
 *Every 15th and end of month, payments are dated on the 15th and end of month (if the 15th or end of month lands on upcoming Saturday/Sunday/holiday, the payments are run up to 15th or end of month)
 *When 15th or end of month (28th-31st) has been recently ran, if the current date less 3 days is before the 15th or end of the month, run until the 15th or end of the month
 :10. Enter '''Due date''' (same date as last payment date)
 :11. Enter '''1''' and '''EFT''' and '''EFT2''' in '''Payment mode'''

@@ Line 59: / Line 59: @@
 *Fridays you have to run payments until Thursday (not 3 days after)
 *If Monday is a holiday, on Friday run the payments until Friday
-*Every 15th and end of month, payments are dated on the 15th and end of month
+*Every 15th and end of month, payments are dated on the 15th and end of month (if the 15th or end of month lands on upcoming Saturday/Sunday/holiday, the payments are run up to 15th or end of month)
 This is to ensure that EFT payments are not paid ahead  of time because discount terms have 4 days taken off for travel time
 :10. Enter '''Due date''' (same date as last payment date)
 :11. Enter '''1''' and '''EFT''' and '''EFT2''' in '''Payment mode'''

@@ Line 116: / Line 116: @@
 ===Delete a Payment Proposal===
-:9. Highlight payment proposal
+:1. Highlight payment proposal
-:10. Select '''Delete''' to delete a payment proposal if there is nothing in proposal
+:2. Select '''Delete''' to delete a payment proposal if there is nothing in proposal
 [[File:EFT15.png|400px]]

← Older revision	Revision as of 23:33, 2 May 2017
Line 1:	Line 1:
	+	==Overview==
	+
	+	By the end of this course, you will be able to:
	+	*Create a payment proposal
	+	*Change a payment proposal
	+	*Delete a payment proposal
	+	*Print a payment proposal
	+	*Create a payment order
	+	*Confirm a payment order
	+	*Update accounts payable
	+
	+	===EFT Process Flow===
	+
	+	[[File:EFT1.jpg\|400px]]
	+
	+	===Supplier Electronic Fund Transfers===
	+
	+	*Supplier that are to be paid via Electronic Funds Transfer (EFT) are configured in ASW as EFT-capable vendors.
	+	*Supplier invoices that are to be paid via EFT are indicated by specifying a payment mode of ‘EFT’ on manual invoice entry or in applications that import invoices. This payment mode can be defaulted to ‘EFT’ if so desired.
	+	*When Accounts Payable staff prepare a payment proposal, a payment of mode of ‘EFT’ is specified when selecting invoices to be paid. Note that EFT and other payment modes, e.g. CHEQUE, should not both be included on the same payment proposal.
	+	*When a payment order is generated from the payment proposal, a file of CIBC EFT transactions is prepared and placed into a shared folder, accessible by both the iSeries and PCs.
	+	*If an EFT vendor is so configured, an OMS email is prepared containing remittance advice information similar to what is now printed on a cheque stub. If the vendor is configured to receive EDI 820 transactions (remittance advice), this information will be passed to the EDI application. If neither of these is set up, a workstation message will be returned indicating that no notification will be sent.
	+	*Mgr, Finance or CFO will sign on to the CIBC Business Banking web site, select the “Upload” function, and select the file from the shared folder.
	+	*The file is sent to CIBC for processing. CIBC will return reports listing the transactions and indicating any errors or warnings in the data.
	+	*Errors will be corrected by making manual adjustments in ASW Accounts Payable and General Ledger as appropriate.
	+	*EFTs are only permitted for Canadian suppliers
	+
	+	==Working with Payment Proposals==
	+
	+	:1. Select '''8 EMS -- Error Mgmt'''
	+	This report will print a listing showing all customers/suppliers with RMADEM email addresses and a second listing of all customers/suppliers which do not have RMADEM email addresses
	+
	+	[[File:EFT2.PNG\|400px]]
	+
	+	:2. Select '''10 EFT -- Vendor emails'''
	+
	+	[[File:EFT3.PNG\|400px]]
	+
	+	Review listings and enter customers/suppliers with missing RMADEM addresses
	+
	+	===Create a Payment Proposal===
	+
	+	:1. Select '''ASW Fastpath'''
	+	:2. Select '''Cash Management'''
	+	:3. Select '''A/P Cash Management Tasks'''
	+	:4. Select '''A/P Payment Tasks'''
	+	:5. Select '''Work with A/P payment proposals'''
	+
	+	[[File:EFT8.png\|400px]]
	+
	+	:6. Select '''Add''' to add new payment proposal
	+
	+	[[File:EFT9.png\|400px]]
	+
	+	:7. Enter '''Proposal description''' (today’s date)
	+	:8. Enter '''First payment date''' (050505)(this date will pick up every outstanding transaction from 050505 to last payment date)
	+	:9. Enter '''Last payment date''' (use current date less 3 days)
	+	Exceptions:
	+	*Fridays you have to run payments until Thursday (not 3 days after)
	+	*If Monday is a holiday, on Friday run the payments until Friday
	+	*Every 15th and end of month, payments are dated on the 15th and end of month
	+	This is to ensure that EFT payments are not paid ahead of time because discount terms have 4 days taken off for travel time
	+	:10. Enter '''Due date''' (same date as last payment date)
	+	:11. Enter '''1''' and '''EFT''' and '''EFT2''' in '''Payment mode'''
	+	:12. Enter '''1''' and '''CAD''' in '''Transaction currency'''
	+	:13. Press '''Enter''' to confirm
	+
	+	[[File:EFT4.png\|400px]]
	+
	+	:14. Change '''Nil supplier balance''' to '''N'''
	+	:15. Change '''Neg supplier balance''' to '''N'''
	+	:16. Press '''Enter'''
	+
	+	[[File:EFT5.png\|400px]]
	+
	+	:17. Change '''Not payables''' to '''N'''
	+	:18. Change '''Printer queue''' to '''PRT01''' (no need to print payment proposal)
	+	:19. Press '''Enter''' to confirm
	+
	+	[[File:EFT6.png\|400px]]
	+
	+	:20. Create next proposal '''OR'''
	+	:21. Press '''F12''' when all proposals have been generated
	+	EFT payments must appear on their own payment proposal. They may not be mixed with other payment modes such as CHEQUE.
	+
	+	[[File:EFT7.png\|400px]]
	+
	+	===Change a Payment Proposal===
	+
	+	:1. Highlight payment proposal
	+	:2. Select '''Change''' to change payment proposal '''OR''' double-click payment proposal
	+
	+	[[File:EFT10.png\|400px]]
	+
	+	:2. Highlight the supplier that includes the invoice you want to maintain
	+	:3. Press '''Enter'''
	+
	+	[[File:EFT11.png\|400px]]
	+
	+	:4. Highlight the invoice you want to maintain
	+	:5. Press '''Enter'''
	+
	+	[[File:EFT12.png\|400px]]
	+
	+	:6. Make changes: payment date, payment amount, cash discount, bank/account number or bank reference no
	+	:*Your selection will pick up a range of dates, you must change all dates to the pay due date (today’s date)
	+	:*If the selection has discount, remove payment amount, leave blank
	+	:7. Press '''Enter'''
	+
	+	[[File:EFT13.png\|400px]]
	+
	+	:8. Press '''F12''' to move back to overview panel
	+
	+	[[File:EFT14.png\|400px]]
	+
	+	===Delete a Payment Proposal===
	+
	+	:9. Highlight payment proposal
	+	:10. Select '''Delete''' to delete a payment proposal if there is nothing in proposal
	+
	+	[[File:EFT15.png\|400px]]
	+
	+
	+
	+	[[Category:Workflows-Finance]]
	+	[[Category:Accounts Payable]]