Difference between revisions of "Accounting Finance:Electronic Fund Transfer-Manual Customer EFT"

From uniWIKI
Jump to navigation Jump to search
(Created page with "==Overview== All EFT customers are balance forward statements which mean they will have statements which only show current transactions and past transactions are in the openin...")
 
 
(16 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
==Overview==
  
==Overview==
−
All EFT customers are balance forward statements which mean they will have statements which only show current transactions and past transactions are in the opening balance. The system will automatically settle the EFT during the Auto Cash process to the oldest invoice/credit note and will post any applicable discounts. Upon request, you might have to run a manual EFT which is not part of the usual 10th and 25th EFT batches. This is required as a 'one off' request in which a customer has requested an EFT to be run earlier/later than the usual 10th and 25th or if the original EFT did not go thru and therefore a manual EFT is required.
 +
All EFT customers are balance forward statements which mean they will have statements which only show current transactions and past transactions are in the opening balance. The system will automatically settle the EFT during the Auto Cash process to the oldest invoice/credit note and will post any applicable discounts. Upon request, you might have to run a manual EFT which is not part of the usual 10th and 25th EFT batches. This is required as an 'one off' request in which a customer has requested an EFT to be run earlier/later than the usual 10th and 25th or if the original EFT did not go thru and therefore a manual EFT is required.
   
−
==Entering Manual EFT into A/R==
 +
==Updating EFT Worksheet==
  +
In order to upload an EFT file to the bank, the file number must be in sequence and there should be no duplicate numbers. Therefore, you should first update the worksheet to obtain the next '''Run ID''' number.
   
  +
#Go to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\CIBC\EFT|CIBC-0100033237-0100023576- Upload Batch Control Log File}}
−
#Click Cash Management→AR Cash Management Tasks→AR Payment Tasks→Enter Financial Transactions
  
  +
#Click either '''EFT-Credits''' or '''EFT-Debits''' sheet
−
#Enter '''Voucher type''' (20)
  
  +
#For credits there will only be '''one''' Run ID but for debits, there will be '''two''' Run IDs (first Run ID is blank)
−
#Enter '''Batch amount'''
  
−
#Press '''Enter'''
 +
#Enter the next '''Run ID'''
  +
#Enter '''Date'''
  +
#Enter '''Detail''' (i.e. Store and account number)
  +
#Enter the '''EFT amount''' under Stmt Balance
  +
#Enter any '''discounts''' under discount
  +
#Enter '''Handler'''
   
−
[[File:ARVT1a.png|400px]]
 +
[[File:Nancy41.PNG|400px]]
   
  +
==Set-up Manual EFT==
−
:9. Enter '''Document type''' (VT)
  
  +
#Goto UWD Extensions→'''1''' UWD Extenstions→'''7''' STM -- Statements→'''11''' View Statement Control Periods
−
:10. Enter '''Document number'''
  
  +
#Enter Type '''EF'''
−
:11. Enter '''Document date''' (use date on notification)
 
  +
#Enter Statement Period (Run ID - next number from your worksheet)
−
:12. Enter '''Debtor number'''
  
  +
#Press '''Enter'''
−
:13. Enter '''Transaction amount'''
 
−
:14. Press '''Enter'''
 +
#Press '''F6'''
  +
#Enter Statement Type '''EF'''
  +
#Enter Period ID ('''next number from your worksheet''')(If it is a EFT debit, please use the period ID for the EFT debit as the import file, as the import file will be using that period ID)
  +
#Enter Start and End Dates (Eg. SEP 25 20)
  +
#Enter Run Type '''M'''
  +
#Enter Timing '''NA'''
  +
#Enter Status '''FI'''
  +
#Press '''Enter'''
  +
#Press '''F12''' twice
   
−
[[File:ARVT2.png|400px]]
 +
[[File:Nancy42.PNG|400px]]
   
  +
==Create Manual EFT==
−
:15. Enter '''Transaction ref''' (payment # entered will be more visible in cashbook reconciliation)
 
  +
#Enter '''11''' (View Statement Control Periods)
−
:16. Press '''Enter'''
  
  +
#Press '''Enter'''
  +
#Enter Statement Type '''EF'''
  +
#Enter '''Period ID'''
  +
#Press '''Enter'''
  +
#Enter '''EE''' next to batch
  +
#Press '''Enter'''
  +
#Press '''F6'''
  +
#Enter '''Customer'''
  +
#Enter A/R Payment Mode '''EFT'''
  +
#Enter '''System EFT Amount'''
  +
#Press '''Enter'''
  +
#Press '''F12''' twice
  +
#Enter '''EP''' next to batch
  +
#Go to Work with Printer Output, highlight printout, click '''Change''', page-down, enter '''lp05''', tab, delete library. and press '''Enter''' twice.
   
−
[[File:ARVT3.png|400px]]
 +
[[File:Nancy43.PNG|400px]]
   
  +
==Post Manual EFT==
−
:17. Enter '''Doc no''' and press '''Enter''' after each document entry '''OR'''
  
  +
===EFT Credit===
−
::Click '''Settlement Diff''' (this option allows you to enter any differences to a specific account (ex. discount)) '''OR'''
  
  +
#Enter '''EC''' next to batch (to export EFT Credit - if not an EFT credit, nothing will process)(Note: Make sure the EFT credits are correct before running '''EC''')
−
::Click '''Fnc list''' and '''21''' (this option allows you to post the unsettled portion of the payment to the account) '''OR'''
  
  +
#Press '''Enter'''
−
::Click '''Maintain item settlement''' (if the store does not take discount, change the paid amount trans to what it was before discount and delete the discount amount)
  
  +
#Enter document date (today's date if the credit has to go through immediately <- generally the case. Does not have to be the same as the start date)
−
:18. Press '''Update''' when completed
  
  +
#Press '''Enter'''
−  
  +
#Enter Voucher type '''27'''
−
[[File:ARVT4.png|400px]]
  
  +
#Enter Document type '''EFT'''
  +
#Enter Identity '''PY'''
  +
#Change printer queue '''lp05'''
  +
#Press '''Enter''' (if not an EFT credit, the message '''Identity PY does not exist in payment file''')
  +
#Press '''F12'''
  +
#Enter '''E1''' next to batch
  +
#Enter '''date'''
  +
#Press '''Enter'''
  +
#Email manager for approval to process the EFT Credits. Attach the following documents, (1) cover page of '''EFT Credits portion from Payment Reconciliation worksheet''', (2) '''Customer Statement Summary of EFT Credits''' (which is generated after running report of EFT < 0 report), and (3) '''GCFP852 report''' (which is generated after '''EC1''' have been completed in mocha, look for file printout in '''Work with All Spooled Files''' for the report).
   
  +
===EFT Debit===
−
:19. Press '''F12''' to move back to previous panel
  
  +
*You do not have to continue if you are only processing an EFT credit.
−
:20. Enter each VT in a separate batch because cashbook will combine multiple entries into one amount
  
  +
#For EFT debit, enter '''ED''' next to batch
−  
  +
#Press '''Enter'''
−
[[File:ARVT5.png|400px]]
  
  +
#Enter document date
−  
−
:21. Press '''F3''' when completed
 +
#Press '''Enter'''
  +
#Enter Voucher type '''27'''
−  
  +
#Enter Document type '''EFT'''
−
[[File:ARVT6.png|400px]]
  
  +
#Enter Identity '''PY'''
−  
−
:22. Press '''F3'''
 +
#Change printer queue '''lp05'''
  +
#Press '''Enter''' (if not an EFT credit, the message '''Identity PY does not exist in payment file''')
−  
  +
#Press '''F12'''
−
[[File:ARVT7.png|400px]]
  
  +
#Enter '''E2''' next to batch
−  
−
:23. Mark '''Close batch'''
 +
#Enter '''date'''
  +
#Press '''Enter'''
−
:24. Enter '''Printer queue''' to '''LP05'''
  
−
:25. Press '''Enter'''
  
−  
−
[[File:ARVT8.png|400px]]
  
−  
−
:26. Press '''Enter'''
  
−  
−
[[File:ARVT9.png|400px]]
  
   
  +
[[File:Nancy44.PNG|400px]]
−
:27. Press '''F12''' to move back to previous panel
  
−
:28. Send notification and registers to scanning station
  
   
  +
==Forward Document to be uploaded to Bank==
−
[[File:ARVT10.png|400px]]
  
  +
#Place an '''EFT Authorization sticker''' on top of all the documents.
  +
#Date and sign the submitted portion of the sticker.
  +
#Forward to Manager, Finance
  +
#The Manager, Finance will uploaded the EFT batch to CIBC and obtain a second authorization signature.
  +
#The Manager, Finance will print confirmation EFT sheet and staple to batch and file in storage box.
   
 
[[Category:Workflows-Finance]]
  
[[Category:Workflows-Finance]]

Latest revision as of 10:15, 28 July 2021

Overview

All EFT customers are balance forward statements which mean they will have statements which only show current transactions and past transactions are in the opening balance. The system will automatically settle the EFT during the Auto Cash process to the oldest invoice/credit note and will post any applicable discounts. Upon request, you might have to run a manual EFT which is not part of the usual 10th and 25th EFT batches. This is required as an 'one off' request in which a customer has requested an EFT to be run earlier/later than the usual 10th and 25th or if the original EFT did not go thru and therefore a manual EFT is required.

Updating EFT Worksheet

In order to upload an EFT file to the bank, the file number must be in sequence and there should be no duplicate numbers. Therefore, you should first update the worksheet to obtain the next Run ID number.

  1. Go to CIBC-0100033237-0100023576- Upload Batch Control Log File
  2. Click either EFT-Credits or EFT-Debits sheet
  3. For credits there will only be one Run ID but for debits, there will be two Run IDs (first Run ID is blank)
  4. Enter the next Run ID
  5. Enter Date
  6. Enter Detail (i.e. Store and account number)
  7. Enter the EFT amount under Stmt Balance
  8. Enter any discounts under discount
  9. Enter Handler

Nancy41.PNG

Set-up Manual EFT

  1. Goto UWD Extensions→1 UWD Extenstions→7 STM -- Statements→11 View Statement Control Periods
  2. Enter Type EF
  3. Enter Statement Period (Run ID - next number from your worksheet)
  4. Press Enter
  5. Press F6
  6. Enter Statement Type EF
  7. Enter Period ID (next number from your worksheet)(If it is a EFT debit, please use the period ID for the EFT debit as the import file, as the import file will be using that period ID)
  8. Enter Start and End Dates (Eg. SEP 25 20)
  9. Enter Run Type M
  10. Enter Timing NA
  11. Enter Status FI
  12. Press Enter
  13. Press F12 twice

Nancy42.PNG

Create Manual EFT

  1. Enter 11 (View Statement Control Periods)
  2. Press Enter
  3. Enter Statement Type EF
  4. Enter Period ID
  5. Press Enter
  6. Enter EE next to batch
  7. Press Enter
  8. Press F6
  9. Enter Customer
  10. Enter A/R Payment Mode EFT
  11. Enter System EFT Amount
  12. Press Enter
  13. Press F12 twice
  14. Enter EP next to batch
  15. Go to Work with Printer Output, highlight printout, click Change, page-down, enter lp05, tab, delete library. and press Enter twice.

Nancy43.PNG

Post Manual EFT

EFT Credit

  1. Enter EC next to batch (to export EFT Credit - if not an EFT credit, nothing will process)(Note: Make sure the EFT credits are correct before running EC)
  2. Press Enter
  3. Enter document date (today's date if the credit has to go through immediately <- generally the case. Does not have to be the same as the start date)
  4. Press Enter
  5. Enter Voucher type 27
  6. Enter Document type EFT
  7. Enter Identity PY
  8. Change printer queue lp05
  9. Press Enter (if not an EFT credit, the message Identity PY does not exist in payment file)
  10. Press F12
  11. Enter E1 next to batch
  12. Enter date
  13. Press Enter
  14. Email manager for approval to process the EFT Credits. Attach the following documents, (1) cover page of EFT Credits portion from Payment Reconciliation worksheet, (2) Customer Statement Summary of EFT Credits (which is generated after running report of EFT < 0 report), and (3) GCFP852 report (which is generated after EC1 have been completed in mocha, look for file printout in Work with All Spooled Files for the report).

EFT Debit

  • You do not have to continue if you are only processing an EFT credit.
  1. For EFT debit, enter ED next to batch
  2. Press Enter
  3. Enter document date
  4. Press Enter
  5. Enter Voucher type 27
  6. Enter Document type EFT
  7. Enter Identity PY
  8. Change printer queue lp05
  9. Press Enter (if not an EFT credit, the message Identity PY does not exist in payment file)
  10. Press F12
  11. Enter E2 next to batch
  12. Enter date
  13. Press Enter

Nancy44.PNG

Forward Document to be uploaded to Bank

  1. Place an EFT Authorization sticker on top of all the documents.
  2. Date and sign the submitted portion of the sticker.
  3. Forward to Manager, Finance
  4. The Manager, Finance will uploaded the EFT batch to CIBC and obtain a second authorization signature.
  5. The Manager, Finance will print confirmation EFT sheet and staple to batch and file in storage box.
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:Electronic_Fund_Transfer-Manual_Customer_EFT&oldid=14034"