Accounting Finance:Amenity Healthcare-Weekly Report

Overview

Each Monday or the next business day after a statutory holiday, prepare the weekly reports and email to payables@amenityhealthcare.com the same day.

Contacts

• Robert Swiscoski T:204-594-5881 rswiscoski@amenityhealthcare.com
• Payables payables@amenityhealthcare.com

Store Accounts

• 4001-Qualicum (12425)
• 4002-Nanoose (12426)
• 4003-Memorial (12424)
• Rita's Apothecary & Home Healthcare (11885)

Receiving File from Information Systems

1. Each Monday you will download three files from IS for the week from Sunday to Saturday (i.e. September 3-September 9, 2017)
2. Log in Infonet. From Finance --> Custom A/R Detail Report. This can only be done through the home/front page (not through uniVIEW).
3. Enter the Account Number for each of the stores (you would run this procedure 3 times, once per store)
4. Enter the correct dates and run
5. Save the files to \\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files
6. Save a second copy with the same name and adding Amenity at the end, as this becomes the working file for making the file adjustments (i.e. 4001-Qualicum (Sep 03-Sep 09, 2017)-Amenity.xlxs)

File Adjustments Prior to sending File

1. Change customer number to numeric (highlight the column (A)→then Data→Test to Column→Delimited→Finish)
2. Delete any documents with the document type EFT
3. Check for duplicate invoice numbers on account types CVM and ELC (ELC should be the last day of the month and CVM should be the first day of the following month)
4. Look for blanks or missing invoices and enter text details for all blanks.

Email Files to Amenity

1. Email reports to payables@amenityhealthcare.com