This report shows a breakdown of everything that has been billed to Space & Time in the most recent billing run. This article will talk you through how to run the report.
Good to know
Must be sent by the 5th working day after month end
How to run the report
- Copy paste actual bill file into bill file folder
- Go to: T:\NH Billing\01 Purchase Order Reports. Run the access report called ‘PO-Billing-Match-v2.0’ Click ’01 Run Reports’, you’ll be notified when the reports have ran.
- The reports will save in T:\NH Billing\01 Purchase Order Reports\03 Report Exports\05 Billing Match Reports, this one is called ‘RM-SpaceAndTime-*DATE*’
- Check that each tab is showing the customer name listed in the tables. If it is not manually go in and filter the table to match the tab.
- Some of the tabs will not be showing the customers that are currently PO’d in which case, right click and hide the tab. Make sure all companies that are PO’d have a separate tab. At the top left there is a drop down for all the company names.
- Bovis do not tend to appear in the report so it’s best to amend one of the tabs so that it says Bovis and filter for Bovis.
- On the final tab called ‘Report_04_SpaceAndTime’ filter on column G called ‘SN Number’ to show any blanks. These are orders that we have no POs for. Check New orders to see if the cover just hasn’t been moved across. Any remaining blanks will often receive queries.
- When checking new orders filter by blank SN numbers and everything but the first of the month.
- Password protect file using the password in Snapshot and Billing Report Access – file, info, protect workbook.
and save the report in T:\NH Billing\01 Purchase Order Reports\03 Report Exports\03 Billing Snapshots\02 Company Reports\Space and Time
10. Send to cx@spaceandtime.co.uk , gabriela@spaceandtime.co.uk, cintia@Spaceandtime.co.uk and accounts@spaceandtime.co.uk.
Subject: Space and Time Billing Breakdown – (Month) Year
Email:
Hi,
I hope you are well.
Please find attached the Space and Time Billing report for (Month) Year.
FAO CX team – any lines with a blank SN number are packages/products that have been billed, which we’re still missing PO cover for. Please send this PO cover over to SpaceandTime@rightmove.co.uk.
The files have been password protected to keep your data safe and secure, please contact either myself or Martin Davies /Sarah Knox /Emily Gomez /Megan Petford for the password to access the files.
Many thanks,
Canned response available
11. Close the ticket as follows: