Accounting Finance:Amenity Healthcare-Weekly Report

From uniWIKI
Jump to navigation Jump to search

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

Store Accounts

  • 4001-Qualicum (12425)
  • 4002-Nanoose (12426)
  • 4003-Memorial (12424)

Receiving File from Information Systems

  1. Each Monday you will receive three files from IS for the week from Sunday to Saturday (i.e. September 3-September 9, 2017)
  2. Save the files to \\superserver.unipharm.local\Accounting\common\AR\Amenity\Weekly files
  3. 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 (AQ)→then Data→Test to Column→Delimited→Finish)
  2. Change date columns (E & F) to recognize the cell as a date type (highlight the two date columns (E & F)→then press CTRL-F to bring up the Find and Replace dialog box, put a hyphen (-) in the Find what box and a backslash (/) in the Replace with box and press the Replace All button). This will immediately replace all of the hyphens with slashes and in doing so will allow Excel to recognize the dates as dates.
  3. Delete any documents with the document type EFT
  4. 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)
  5. Look for blanks or missing invoices and enter text details for all blanks.

Email Files to Amenity

  1. Email reports to payables@amenityhealthcare.com
Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:Amenity_Healthcare-Weekly_Report&oldid=9778"