SHAW REPORT - 1ST VERSION (Do at start of Month ) -XXXXXXXXXXXXX

SHAW REPORT - 1ST VERSION (Do at start of Month ) -XXXXXXXXXXXXX





SHAW REPORT

The Shaw report is a report/process that we use to obtain cost of goods figure for accounting ,its very important that it is kept accurate
 
Before we start this task for the month ,ensure that all cars purchased last month are entered into pinnacle 

MAKE SURE ALL SALES FIGURES FROM THE PREVIOUS MONTH ARE ENTERED FIRST

 ===============================================================
STAGE 1 - FILLING IN DATA INTO GOOGLE SHEETS 


The shaw report gives our estimate of inventory cost , we will update cells in green and result with show

FOR FIRST DRAFT WE COLOR CELLS ORANGE ,THAT ARE ESTIMATES
FOR FINAL DRAFT WE COLOR CELLS GREEN

----------------------------------------------------------------------------------------------------------------------
***COLUMN B: TOWING FEES*** - XERO    (TIP DO COLUMNS B, E, F AND G IN ONE STEP ) 


TO GET THIS DATA 
- Go to XERO - accounting - Reports tab -> All Reports -> Performance Reports area, click Profit and Loss

- From Profit & Loss report -> Click Show Date Range tab -> From & To: Dates/months you need; Compare With: NONE; Compare Periods: NONE

- CTRL + F: Type "TOWING" -or- scroll towards the end of the page, find Towing under Freight

- Enter the figure that you need from the P&L report to Shaw Report 

--------------------------------------------------------------------------------------------------------
***COLUMN C: # OF VEHICLES*** - PINNACLE 


- Log in to Pinnacle -> Management -> Vehicle Reports -> V2 Vehicle Stock

- Date Range (MVR Entered) -> Select from dropdown menu: Previous Month (or whatever period you need) -> OK

- Go to last page of V2 Vehicle Stock Report -> Get figure of Overall Total MVRs -> Enter figure in Shaw Report Column C: # OF VEHICLES

----------------------------------------------------------------------------------------------------------------
***COLUMN D: $ SPENT FOR VEHICLES (NO TOWING )*** - XERO 

- Go to Accounting - Reports - Accounting  ->  click Account Transactions

- Account: 11300 - Inventory -> From & To: Period that you need -> Update

- Scroll down towards the end of the page/report and make sure you're Showing 200 items per page

- Pick up Total Amount (amount before Closing Balance) -> Enter figure in Shaw Report Column D: $ Spent For Vehicles (No Fees)



-------------------------------------------------------------------------------------------------------------------

***COLUMN E: PARTS SOLD FROM INVENTORY*** - XERO 

- Go to Reports tab -> All Reports -> Performance Reports area, click Profit and Loss

- From Profit & Loss report -> Click Show Date Range tab -> From & To: Dates/Month you need; Compare With: NONE; Compare Periods: NONE

- Add up the figures of JJAP EXTRA + JJAP INVENTORY + JJAP NEW (all under Income part of P&L)

- Enter the sum figure of the three to Shaw Report Column E: PARTS SOLD FROM INVENTORY

-----------------------------------------------------------------------------------------------------------------
***COLUMN F: SCRAP METAL SALES*** - XERO 

Look at profit and loss - SCRAP METAL SALES
draft 1 - copy from previous months
Final (Make sure this has been entered into xero - this is seperate task)

----------------------------------------------------------------------------------------------------------------------

***COLUMN G: GROSS PROFIT $ NEEDED***

Column G: For the FIRST DRAFT REPORT, put $575,000 as initial gross profit (updated november 2021 ) 

- Go to Reports tab -> All Reports -> Performance Reports area, click Profit and Loss

- From Profit & Loss report -> Click Show Date Range tab -> From & To: Dates/Month you need; Compare With: NONE; Compare Periods: NONE

- Pick up Gross Profit figure and enter the figure to Shaw Report Column G: GROSS PROFIT $ NEEDED

******************************************************************
STAGE 2 - FILLING IN DATA FROM SHEETS TO XERO 

XERO JOURNAL ENTRY - UPDATE ENTRY EVERY TIME WE UPDATE THE SPREADSHEET

For the draft find last months shaw figure from the Profit and Loss report , copy it and change the amounts and the date 






JOURNAL ENTRY  

Line 1. Last months parts sold costs of goods.
Line 3. Crush core and scrap cost of goods

Line 2 . Balances the Journal.