1. In Windows file explorer, open path "cyp.org.au\ICT - Documents\15. Telecommunications\Bills"
  2. Copy and paste the previous month, and rename it to the current period.
  3. Rename the Reconciliation .xlsx file to the current period.
  4. Delete the first two files (both pdf files example below name will be different..)
  5. Open Browser, Login to telstra.com.au
  6. Sign In - My business account "tb329011"
  7. Go to "Online Billing" under "Your Quick Links" (or Online Bill - Account Summary (telstra.com.au)) 
  8. Ensure that Account 1338260600 is selected at the top right hand corner
  9. Change Bill Issue date at the top right hand corner to the current period and click "Display".
  10. Click "Print Page"
  11. Save PDF as "Online Bill - Account Summary.pdf" Overwriting the old file in the repository.
  12. Repeat this process but change the drop down box to New Charges.
  13. Click "View Service List Incl GST" 
  14. Click Print Page
  15. Print as PDF, over-write file "Online Bill - Service List.pdf"
  16. Then Click "Download"
  17. Click "Go" in orange (ensure that the file type is csv).
  18. Copy the file from where it was downloaded and paste it into the repository.
  19. Delete the .csv file that is already in the folder, it was last months csv, we are about to re-generate it.
  20. Rename the choose.do file to the current bill number, followed by the date in reverse order, and make sure the file type is a csv. An example is below.. 
  21. Back to the Telstra site, Click "Downloads Bills" in the navigation pane on the far left.
  22. Under Account, select the account that is listed as 1338260600
  23.  Under Bill, select the current period.
  24. Under Bill format, select "your summary bill"
  25. Click "Add Another"
  26. Repeat the process but select "Your Detailed Bill" instead.
  27. Click "Submit"
  28. If required refresh the page, and download the zip file, ensure that it is the correct request date (ie: Todays date).
  29. Open the zip file and extract the files to the repository folder.
  30. In windows explorer, open file "cyp.org.au\ICT - Documents\15. Telecommunications\Bills\Telstra Bills.accdb"
  31. If required (if the yellow bar is showing at the top) Click "enable content" at the top of the page.
  32. Check that the "Last imported Bill Date" is the previous month.
  33. Click "select and import telstra bill CSV"
  34. Locate the CSV file, it should look like this.. 
  35. Check "Last imported Bill Date" ensure it is the CURRENT month. That you just imported.
  36. Run Step 1 in the Telstra Bills.accdb file.
  37. Only run these steps in italic only if data found in step 1
  38. Locate the mobile number on the bill.
  39. On the CYP Intranet go to "Business Services" http://cypintranet.capeyorkpartnerships.com/business/Lists/CYP%20Mobile%20and%20Modems/AllItems.aspx 
  40. Locate the user, if they do not exist, then create them using the appropriate details from any emails or tickets.
  41. When creating the user, Fill supplier and Invoice details.
  42. Add a comment relating to Mobile History.
  43. Copy the info back into the database, under qry_monthlybillingdata_missing_services_costcode_info find the cost code from the appropriate manager.
  44. Close  qry_monthlybillingdata_missing_services_costcode_info tab
  45. Run Step 2 but only if Data is found in step 1, otherwise - skip (click "yes" both times to add the records).
  46. Open the xlsx file it should look like this.. 
  47. Delete the previous months worksheet.
  48. While in the current month spreadsheet, go to "sort and filter" and click on clear.
  49. Duplicate the current month worksheet and rename it the current period name. Save worksheet.
  50. Switch to the "Reconciliation" worksheet.
  51. Move the two columns from this..To this..
  52. Go back to the Access database and run step 5.
  53. From the data produced, copy the data and paste it into the current months worksheet.
  54. Then from the current months worksheet.
  55. In the current Month, cut columns Difference (F) and Reasons (G) and then "insert cut cells" after column I
  56. Copy Column H from the previous month and "insert Copied cells" into the current month after column "G"
  57. Copy the difference and reasons columns (I and J)  from the previous worksheet and paste it into the I Column of the current month sheet replacing what was there in both columns.
  58. Go down to the bottom of the current month sheet, expand the cells down in columns H and I if there are blanks.
  59. In Column H, click the drop-down box and un-check "inactive"
  60. In column I, click on the drop-down box and un-check "0"
  61. Look through the Differences column and see if there are any large discrepancies (generally for mobiles) Land-lines aren't particularly important here, mainly focus on mobile phones.
  62. Go back to the database, close "qry_crossab_view_all_bills" tab and then run "Step 6"
  63. Copy the data generated from step 6
  64. Paste the data in the reconciliation excel document, and then delete any remaining rows that were'nt pasted in.
  65. Copy the amounts from "COMMON" and "COMMON MOBILE" and paste into the corresponding cells in column E. Make sure that the amounts are copied only not cut!
  66. Then delete the data from "COMMON" and "COMMON MOBILE" (in Column D)
  67. Highlight the 3 rows after "COMMON' and "COMMON MOBILE" right click, and click on "Insert". This should create 3 blank rows.
  68. Move previous cells that were moved in step 51 back to their original location - see screenshots above in step 51.
  69. Open the Account summary pdf and transcribe the "bill rounding" value to the reconciliation spreadsheet.
  70. Check that the Bill total figure on the spreadsheet equals the New charges figure.
  71. If the figures are correct, email Shaneen and CYP Accounts.
  72. Make subject : Telstra Bills Jan and Feb 2021.
  73. Share the folder via one drive and provide a link to the folder in the body of the email.