Billable Items Reconciliation

Each month the MSF billable items need to be reconciled with the invoices. In order to aid this process a spreadsheet is produced detailing the items that were not imported and the various counts of billable items. The process for its production is:

1. Open the Billable Items Reconciliation Base Template
2. Save it as "Billable Items Reconciliation <month> <year>.xlsx in the same folder - Support Documents\Franchise Hub\
3. Go into the MSF Reports screen of the Admin Hub and run the Billable Items Report for All Networks for the current month
4. Open the CSV that is downloaded and copy the data (but not header) to cell B2 of the "Billable Items Report" tab of the Reconciliation file.
5. Populate columns A, H and I by dragging down the values of row 2 or double clicking the cross at the bottom right of cells A2, H2 and I2
6. Open the CSV that was uploaded for the Office 365 import and copy the data (but not header) to cell B2 of the "O365" tab of the Reconciliation file.
7. Populate columns A and I by dragging down the values of row 2 or double clicking the cross at the bottom right of cell H2.
8. Open the CSV that was uploaded for the Jupix import and copy the data (but not header) of columns B to H to cell A2 of the "Jupix" tab of the Reconciliation file.
9. Populate column H by dragging down the values of row 2 or double clicking the cross at the bottom right of cell H2.
10. Open the CSV that was uploaded for the Reapit import and copy the data (but not header) to cell A2 of the "Reapit" tab of the Reconciliation file.
11. Populate column I by dragging down the values of row 2 or double clicking the cross at the bottom right of cell H2.
12. Open the CSV that was uploaded for the Alto import and copy the data (but not header) to cell B2 of the "Alto" tab of the Reconciliation file.
13. In the Alto tab populate the column "A" with "Hunters" for Hunters users and "MAC" for Martin & Co users.
14. Populate column I by dragging down the values of row 2 or double clicking the cross at the bottom right of cell H2.
15. On the Calculations tab of the Reconciliations spreadsheet right click in cell A4 and select "Refresh"
16. Send the spreadsheet to Suzanne.