Here's how to create sales reports for the services/products.

1. Creating Spreadsheets for Sales Report.
   E.g. I'll use Bin Deliveries for this tutorial
   1. Find a copy of the .xlsx file of Bin Deliveries. "XXXX to XXXX Bin Deliveries.xlsx"
       
   2. Go to Z:\Australian Waste Management\Current Year\Archiving\Accounts\Management Reports\Bin Deliveries for the xlsx file.
      
       
   3. "2401 to 2507 Bin Deliveries.xlsx" the first set of numbers is the start date (January 2024) and the second set is the end date (July 2025).
      Start date depends on what you're looking for, safe bet is the start of the current year or the previous year. End date would be better if the previous month of your current date. Unless there is a requested start and end date.
       
   4. Copy the file and rename with current date (YYMM). Open the files to check the content. So your new file would be something like: "2501 to 2601 Bin Deliveries.xlsx" - January 2025 to January 2026 Bin Deliveries.
      1. Bin Deliveries.xlsx is the sales report of the bin deliveries. Two (2) sheets: One for the Graphs and Tables, the other for the Raw Data we will be using.
            
          
      2. Let's start with Raw Data. We need to update the data. 
         1. Launch and login to MYOB.
            
             
         2. Go to Reports and go to Sales tab.
               
             
         3. Click Sales [Item Detail]. Input the start and end date. In this example, I'll be using January 01, 2025 to July 31, 2025 for this tutorial. Click Display Report after.
            
             
         4. The sales report will open. Let it finish generating the pages. Once it is finished generating, click the selection box on the right of Items: 
               
             
         5. A window will appear after to select which items would be displayed. As I am doing a tutorial for Bin Deliveries, I'll input "Delivery" in the search box and check the boxes for the items that fall under Bin Deliveries. Click Ok after. Click Run Report to regenerate the sales report with only the items we are looking for.
                  
             
         6. Time to export the sales report. On the upper left, click on the drop down list. Select Export and Excel. Wait for a few, then an excel file will open.
                  
             
         7. This is the sales report for Bin Deliveries from MYOB. We will use the date here and input to our file.
            
             
      3. Now we have the data, back to the Bin Deliveries file.
         1. I color coded each service for clarity so you can follow that or create your own. Also, the Date column has a code to simplify the date from the report into a simpler version.
               
             
         2. Start copying and pasting from the sales report to your xlsx file. Copy the data from all columns of the sales report, be mindful that the Date column of your file that it isn't changed.
            Check the cell of the Date column. It should have "=DATEVALUE(C2)" to convert the date into a simpler format. Update the table on the right with the quantity of the service and amount.
            Do the same with the other services that the sales report from MYOB has exported.
            
             
         3. Once, you are finished encoding the data, double check the content.
            
             
      4. Time to create the Graphs and Tables.
         1. Select a service and other items of that service. Don't forget to include the Header Tables.
            
             
         2. Go to Insert tab and click Pivot Table.
            
             
         3. A window will open to create a PivotTable. Select Existing Worksheet. Input the location where the table will be placed. You can use the the button near the input box to select the cell.
             
             
         4. On the right side, the PivotTable Fields. Check Date, Quantity, Item in Service, and Year/Month if available. Follow the format of the columns, rows, and values. Do the same for the other services.
            I move the rows that have already been completed underneath to mark them as done while moving up the rest. Make sure to group the CM, DD, GW, and PC items.
                        
            
            Note: To avoid blank spaces. Right Click a PivotTable, Select PivotTable Options. In Format, place a check on the checkbox for "For empty cells show:" then input "0" in the input box.
            
             
         5. Now you have the PivotTables. Cut and paste them to the Graphs & Tables worksheet. Move each table to their corresponding labels.
               
             
         6. Now click on a whole table. Go to Insert Tab and locate the Line Chart. Click the Line Chart. Locate and click the Line with Markers.
               
             
         7. Move and resize the chart and content to your specifications.
            
             
         8. Do the same with the other tables. Double check the contents.
               
             
         9. Once you are done double checking, you are now done. Save it and make sure it is on the same directory, "Z:\Australian Waste Management\Current Year\Archiving\Accounts\Management Reports\Bin Deliveries" with the other files like it.