2.1 Reporting

Hudson’s Bay A/R Process

To be completed First week of every month.

1. Log in to RQ4
2. Open up Company profile for Hudson’s Bay Company
3. Go to General, then tab titled “Accounts”
4. Click on the link under column heading “account number”: NYORKAR221
5. Click on NYROKAR221 to open current A/R statement
6. Print all invoices from previous months, cross reference on the AR statement, then give AR statement and all invoices to Lucy

Globe and Mail A/R Process

To be completed First week of every month.

1. Log in to RQ4
2. Open up Company profile for Globe and Mail
3. Go to General, then tab titled “Accounts”
4. Click on the link under column heading “account number”: NYORKAR534
5. Click on NYROKAR534 to open current A/R statement
6. Print all invoices from previous months, cross reference on the AR statement, then give AR statement and all invoices to Lucy

MGS Reporting

Must be completed on the 15th of every month

Steps:

Templates are found in: Z:\CORPSERV\Account Managers\ROBERT GRAHAM\MOL\MGS Reporting\templates

1. Create a new folder in Z:\CORPSERV\Account Managers\ROBERT GRAHAM\MOL\MGS Reporting
   1. Under the folder of the current year
   2. Titled for the month you are completing it for (e.g. August to September)
2. Amend the three templates found in the following folder: Z:\CORPSERV\Account Managers\ROBERT GRAHAM\MOL\MGS Reporting\templates
   1. Change dates to reflect the current dates
   2. Add data if there were any MGS orders processed that month
3. Send the “Raw Data Report” to: carlo.mastroluca@bell.ca, frederick.belanger@bell.ca , patrick.piche@bell.ca, susan.cummings@bell.ca and robg@wpci.com
4. Send the “Bell – OPS Device Redistribution RRD” report and “SOM Service Order and Service Request Report” to: lindsy.kendall@bell.ca, patrick.piche@bell.ca, susan.cummings@bell.ca and robg@wpci.com

Request Report” to: lindsy.kendall@bell.ca and robg@wpci.com

Sobey’s A/R Process

Statements for Sobeys will be from the 12th to the 11th of any given month.

To be completed on the week of the 15th of every month

1. Open template from Corpserv this location: Z:\CORPSERV\Account Managers\ROBERT GRAHAM\Sobeys Monthly AR Statements
2. In RQ4; Open up “Sobey’s Inc”
3. Go to General and click tab titled “accounts”
4. Click on the link under column heading “account number” to open up current A/R statement
5. Create a new folder in the destination under the current year titled “Sobeys Statement {month name} 12 to {month name} 11”
6. Open all invoices for the statement period, and save in the new folder created with the following file name:
   1. V271616-INYORKIN##### (For example, if invoice # is NYORKIN44488, the file name should be: V271616-INYROKIN44488)
7. Open each invoice and insert data into spreadsheet. The date format must match the following: yyyy/mm/dd

8. Send spreadsheet and all saved invoices in one email to Lisa.Leblanc2@sobeys.com with a copy to robg@wpci.com.
9. Ensure the formatting on the spreadsheet is standardized. Numbers, Format, Text and alignment should all be the exact same format (use Format Painter to ensure they are all the same). Failure to Format this correctly will result in the spreadsheet being returned to us to redo.

Every invoice should have a mobile number and user name, if missing, you will have to go through the original order to obtain this information before you can submit for payment

Any invoice with two mobile numbers/users should be split using a v2 at the end of the label and add a row in the excel.  For example, V271616-INYORKIN12345v2.