Mikeg: Created page with "==A/R Customer Statements== Under option - enter '''2''' Click '''enter''' Under option - enter '''1''' Click '''enter''' Under option - enter '''1''' Click '''enter'''..."

2017-12-27T17:09:31Z

Created page with "==A/R Customer Statements== *Under option - enter '''2''' *Click '''enter''' *Under option - enter '''1''' *Click '''enter''' *Under option - enter '''1''' *Click '''enter'''..."

New page

==A/R Customer Statements==
*Under option - enter '''2'''
*Click '''enter'''
*Under option - enter '''1'''
*Click '''enter'''
*Under option - enter '''1'''
*Click '''enter'''
*Under option - enter '''7''' (statements)
*Click '''enter'''
*After statements have been completed, enter '''11''' (View Statement Control Periods)
*Click '''enter'''

==Show List of A/R Statements Control Periods==
*Under the period you wish to generate an A/R EFT batch - enter '''EG'''
*Click '''enter'''
*The control period must be status FI finished, and the EFT Status must be IP in process.
[[File:EFTA1.png|400px]]

*To print the generated batch - enter '''EP'''
*Click '''enter'''
*The control period must be status F1 finished, and EFT Status must be IP Process.
*The report is sent to the user’s work with printer output spool files.
*Retrieve it and change printer queue to print.

*To edit the generated batch - enter '''EE'''
*Click '''enter'''
*The control period must be status F1 finished, and the EFT transactions can be in any status
*Make sure all changes are made!

===Show List of EFT Transactions===
*You can use the ‘Customer’ and “Statement Number’ select fields to list the selected transaction only.
*You can use the fields in the upper right hand corner to select groups of transactions, i.e. negative EFT amounts.
*Transactions can be deleted with the PU purge option.
*Click '''F6''' to add a customer not listed
*MA main info will allow you to change the A/R payment mode or the amount.
[[File:EFTA2.png|400px]]

===Update EFT Transactions===
*You can use ? To prompt for A/R payment modes that are valid for the customer (i.e. another EFT account)
*You can change the amount
*Click '''F12''' twice to get back to A/R Statement Control Periods panel
[[File:EFTA3.png|400px]]

===Show List of A/R Statements Control Periods===
*After the payment proposal has been reviewed, print the generated batch again after making any changes- enter '''EP'''
*Click '''enter'''
*The report is sent to the user’s work with printer output spool files.
*Retrieve it and change printer queue to print.
*Go to Credit Card &EFT Reconciliation worksheet and enter reconciliation amounts (superesrver/accounting/common/ar/2012-2013/Customer Payments/Credit Card & EFT Reconciliations). *Enter Customer Statement Summary and any individual statements regenerated after statements have been printed.
*Review full Customer Statement Summary and review all credit balances and enter any missing ones on reconciliation worksheet.
*Attach a label onto the last page of the report and place it into the yellow folder before forwarding it to the Manager, Finance for approval.
*Note 2 signing officers are required to sign the payment proposal.

*'''To Generate EFT Credit Postings'''
*After the payment proposal has been approved, to export the EFT credits - enter <EC>
*Click '''enter'''
*This will create a CIBC EFT transaction file, and write it to the folder EFT (in the 525’s IFS) to be sent to CIBC via their Business Banking web site.
*The control period must be status F1 finished, and the EFT Status must be IP in process.
*AR transactions created and written to SROKBP; G/L transactions are created and written to SROIBT. The G/L interface file will be automatically posted to ASW.
*Enter the due date which should be either the 16th or 01st of each month
*Click '''enter'''
[[File:EFTA4.png|400px]]

===A/R Batch Payment Update===
*Enter the voucher type '''27''' (EFT A/R)
*Enter the document type '''EFT'''
*Enter the identity '''PY'''
*Change the printer queue '''lp05'''
*Click '''enter'''
*'''This will run in batch, so go to “Work with Messages” and make sure there are no errors and the batch has been posted. If the batch has not be posted properly, the cash book posting will not be created correctly.'''
*If you get a message saying there was an error, ask Nancy and if Nancy is not available ask IT to correct it and repost in “Work with Journals in Errors”
*The report is sent to the user’s work with printer output spool files.
*Retrieve it and change printer queue to print.
[[File:EFTA5.png|400px]]

===Show List of A/R Statements Control Periods===
*After the credit payment proposal has been exported, to update cashbook - enter '''E1'''
*Click '''enter'''
*This will add a record to the cashbook transaction file, and update the cashbook bank balances.
*The control period must be status F1 finished, and the EFT Status must CR EFT done.
*AR transactions crated and written to SROKBP; G/L transactions are created and written to SROIBT. The G/L interface file will be automatically posted to ASW.
*Enter the due date which should be either the 16th or 01st of each month
*Click '''enter'''

==Enter into Control Worksheets==
*If the EFT payment proposal has been approved, the Manager, Finance will upload EFT file to CIBC
*Update the control worksheet (superserver/accounting/common/ar/2012-2013/customer payments/EFT Confirmations and Rejections/CIBC-0100033237-0100023576-Upload Batch Control Log (Feb 01-Jan 31 2013),
*Manager, Finance will print CIBC EF#3501 Input File Totals Report (the day after upload to CIBC) and file.

*Prepare EFT Debit Reconciliation worksheet
*Go to Credit Card &EFT Reconciliation worksheet and enter reconciliation amounts (superesrver/accounting/common/ar/2012-2013/Customer Payments/Credit Card & EFT Reconciliations).
*Enter Customer Statement Summary and any individual statements regenerated after statements have been printed.
*Deduct any accounts paid by credit card but on Customer Statement Summary report.
*Remove Somass Drugs (will call when ready to pay via EFT)
*Remove Tabor Pharmacy and re-enter new amount after calling Samy to find out the amount is he paying.
*Medicine Chest should automatically be removed and remaining balance entered.
*Remove MacDonald’s Pres #3 if they are paying by credit card (month end only)

==A/R Customer Statements==
*'''To Generate Debit EFT Postings'''
*After statements have been completed, enter '''11''' (View Statement Control Periods)
*Click '''enter'''

===Show List of A/R Statements Control Periods===
*'''Before posting debit payment, you must edit any changes.'''
*To edit the generated batch - enter '''EE'''
*Click '''enter'''
*The control period must be status F1 finished, and the EFT Status can be in any status

===Show List of EFT Transactions===
*You can use the ‘Customer’ and “Statement Number’ select fields to list the selected transaction only.
*You can use the fields in the upper right hand corner to select groups of transactions, i.e. negative EFT amounts.
*Transactions can be deleted with the PU purge option.
*Click '''F6''' to add a customer not listed
*MA main info will allow you to change the A/R payment mode or the amount.

===Show List of A/R Statements Control Periods===
*After the payment proposal has been reviewed, print the generated batch again after making any changes- enter '''EP'''
*Click '''enter'''
*The report is sent to the user’s work with printer output spool files.
*Retrieve it and change printer queue to print.
*'''Complete reconciliation worksheet with printed report amounts.'''
*'''Make sure the total is the same as your summary report (after adjustments).'''
*Attach a label onto the last page of the report and place it into the yellow folder before forwarding it to the Manager, Finance for approval.
*Note 2 signing officers are required to sign the payment proposal.

*After your proposal has been approved, to export the EFT debits - enter '''ED''' (create this a couple business days before the due date)
*Click '''enter'''
*This will create a CIBC EFT transaction file, and write it to the folder EFT (in the 525’s IFS) to be sent to CIBC via their Business Banking web site.
*The control period must be status F1 finished, and the EFT Status must be C1 Cash Bk.
*AR transactions crated and written to SROKBP; G/L transactions are created and written to SROIBT. The G/L interface file will be automatically posted to ASW.
*Enter the due date which should be either the 10th or 25th of each month
*Click '''enter'''

===A/R Batch Payment Update===
*Enter the voucher type '''27''' (EFT A/R)
*Enter the document type '''EFT'''
*Enter the identity '''PY'''
*Change the printer queue '''lp05'''
*Click '''enter'''
*'''This will run in batch, so go to “Work with Messages” and make sure there are no errors and the batch has been posted. If the batch has not be posted properly, the cash book posting will not be created correctly.'''
*If you get a message saying there was an error, ask Nancy and if Nancy is not available ask IT to correct it and repost in “Work with Journals in Errors”

===Show List of A/R Statements Control Periods===
*After the debit payment proposal has been exported, to update cashbook - enter '''E2'''
*Click '''enter'''
*The control period must be status F1 finished, and the EFT Status must be DR EFT done.
*AR transactions crated and written to SROKBP; G/L transactions are created and written to SROIBT. The G/L interface file will be automatically posted to ASW.
*Enter the due date which should be either the 10th or 25th of each month
*Click '''enter'''
*The report is sent to the user’s work with printer output spool files.
*Retrieve it and change printer queue to print.

===Create Manual EFT Batch===
*To Create a manual batch - click '''F6''' to add
#Enter Statement Type '''EF'''
#Enter Period Id. (enter the last EFT batch number)
#Enter Start and End Date (use current date)
#Enter Run Type '''M'''
#Enter Timing '''NA'''
#Enter Status '''FI'''
#Click '''enter'''
#Click '''F12'''
[[File:EFTA6.png|400px]]

*Enter Type '''EF''' to show only manual batches
*Enter '''EE''' to edit batch
*Click '''enter'''

*Click '''F6'''to add a customer not listed
#Enter A/R Payment Mode '''EFT'''
#Enter Customer
#Enter EFT Amount (enter negative for EFT credit)
#Click '''enter''' twice
*Click '''F12''' twice

*Continue with the same process as if this batch had been generated from statement.
*Go to FIN/AR/EFT/AUTO/12 for EFT credit (if the manual EFT is not a credit – you still need to run EFT credits but it will have no transactions)
*Go to FIN/AR/EFT/AUTO/17 to run EFT debit

==Enter into Control Worksheets==
*Update the control worksheet (superserver/accounting/common/ar/2012-2013/customer payments/EFT Confirmations and Rejections/CIBC-0100033237-0100023576-Upload Batch Control Log (Feb 01-Jan 31 2013).
*Forward documents to Manager, Finance who upload the EFT file to CIBC
*Manager, Finance will print CIBC EF#3501 Input File Totals Report (the day after upload to CIBC) and forward to A/R Co-ordinator for filing

[[Category:Workflows-Finance]]
[[Category:Accounts Receivable]]

Accounting Finance:Cash Receipts (EFT-automated) - Revision history

Mikeg: Created page with "==A/R Customer Statements== *Under option - enter '''2''' *Click '''enter''' *Under option - enter '''1''' *Click '''enter''' *Under option - enter '''1''' *Click '''enter'''..."

Mikeg: Created page with "==A/R Customer Statements== Under option - enter '''2''' Click '''enter''' Under option - enter '''1''' Click '''enter''' Under option - enter '''1''' Click '''enter'''..."