SHAW REPORT- Final Data entry- Updated July 2017 XXXXXXXXXXXX

SHAW REPORT- Final Data entry- Updated July 2017 XXXXXXXXXXXX







In stage one of the Shaw report we will enter in the data that is available so we can get approximate end of month figures
In stage 2 all data should be entered so we review this and enter in final figures for that month

LINK TO SHAW REPORT

The estimated figures are entered in orange , once we enter in final figures we color the cells green

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

As per step one we obtain data and fill in cells
TIP :DO DATA FOR COLUMNS B,E AND F IN ONE STEP

***COLUMN B: TOWING FEES*** - XERO   

TO GET THIS DATA 
Go to XERO Reports tab -Profit and Loss
Look at the previous month Data

- 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 ,as you update color the cell green

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

***COLUMN E: PARTS SOLD FROM INVENTORY/EXTRA AND NEW *** - XERO 

TO GET THIS DATA 
Go to XERO Reports tab -Profit and Loss
Look at the previous month Data


- 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 

TO GET THIS DATA 
- Go to XERO Reports tab -Profit and Loss -
Look at the previous month Data

Scrap metal sales
Look at the previous month Data

Final (Make sure this has been entered into xero - this is seperate task)
----------------------------------------------------------------------------
***COLUMN G: GROSS PROFIT $ NEEDED***

TO GET THIS DATA 
Go to XERO Reports tab -Profit and Loss
Look at the previous month Data

Column G: For the FIRST DRAFT REPORT, we have put $400,000, for final shaw report we put the gross profit figure as shown in profit and loss   

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

- Go to Reports tab ->
All Reports ->
Detail Reports area,
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)

(IN EXAMPLE BELOW THE FIGURE WE USE IS $471,224)

----------------------------------------------------------------------------------------------
***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



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

STEP 2 - UPDATE THE SHAW REPORT FIGURE IN XERO

Enter updated figures into Xero