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...")
 
m
Line 2: Line 2:
 
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 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.
   
−
==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 duplicate numbers will be rejected. 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 first 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)
 
−
:12. Enter '''Debtor number'''
 +
#Enter Statement Period (next number from your worksheet)
  +
#Press '''Enter'''
−
:13. Enter '''Transaction amount'''
 
−
:14. Press '''Enter'''
 +
#Press '''F6'''
  +
#Enter Statement Type '''EF'''
  +
#Enter Period ID (next number from your worksheet)
  +
#Enter Start and End Dates
  +
#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 credit EFT - if not a credit EFT, nothing will process)
−
::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
−
:18. Press '''Update''' when completed
  
  +
#Press '''Enter'''
  +
#Enter Voucher type '''27'''
  +
#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'''
   
  +
===EFT Debit===
−
[[File:ARVT4.png|400px]]
  
  +
*You do not have to continue if you are only processing an EFT credit.
−  
−
:19. Press '''F12''' to move back to previous panel
 +
#For EFT debit, enter '''ED''' next to batch
  +
#Press '''Enter'''
−
:20. Enter each VT in a separate batch because cashbook will combine multiple entries into one amount
  
  +
#Enter document date
−  
  +
#Press '''Enter'''
−
[[File:ARVT5.png|400px]]
  
  +
#Enter Voucher type '''27'''
−  
  +
#Enter Document type '''EFT'''
−
:21. Press '''F3''' when completed
  
  +
#Enter Identity '''PY'''
−  
  +
#Change printer queue '''lp05'''
−
[[File:ARVT6.png|400px]]
  
  +
#Press '''Enter''' (if not an EFT credit, the message '''Identity PY does not exist in payment file''')
−  
−
:22. Press '''F3'''
 +
#Press '''F12'''
  +
#Enter '''E2''' next to batch
−  
  +
#Enter '''date'''
−
[[File:ARVT7.png|400px]]
  
  +
#Press '''Enter'''
−  
−
:23. Mark '''Close batch'''
  
−
:24. Enter '''Printer queue''' to '''LP05'''
  
−
:25. Press '''Enter'''
  
−  
−
[[File:ARVT8.png|400px]]
  
−  
−
:26. Press '''Enter'''
  
−  
−
[[File:ARVT9.png|400px]]
  
−  
−
:27. Press '''F12''' to move back to previous panel
  
−
:28. Send notification and registers to scanning station
  
   
−
[[File:ARVT10.png|400px]]
 +
[[File:Nancy44.PNG|400px]]
  +
==Forward Document to be uploaded to Bank==
  +
#Place a EFT Authorization sticker on top of all the documents.
  +
#Date and sign the submitted portion of the sticker.
  +
#Forward to Managaer, Finance
  +
#The Manager, Finance will uploaded the EFT batch to CIBC and obtain a second authorization signature.
   
 
[[Category:Workflows-Finance]]
  
[[Category:Workflows-Finance]]

Revision as of 13:57, 26 October 2017

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.

Updating EFT Worksheet

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

  1. Go to {{unc|\\superserver.unipharm.local\Accounting\common\AR\Banking\CIBC\EFT|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 first 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 (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)
  8. Enter Start and End Dates
  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 credit EFT - if not a credit EFT, nothing will process)
  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 E1 next to batch
  12. Enter date
  13. Press Enter

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 a EFT Authorization sticker on top of all the documents.
  2. Date and sign the submitted portion of the sticker.
  3. Forward to Managaer, Finance
  4. The Manager, Finance will uploaded the EFT batch to CIBC and obtain a second authorization signature.
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:Electronic_Fund_Transfer-Manual_Customer_EFT&oldid=9677"