Cash Bag JournalThe Cash Bag Journal report is designed for companies that provide cash for their vehicle drivers to purchase goods during their job. These purchases are recorded in the Autos module on the Expense tab.
Using the settings at the top of the report, select:
- Vehicle – chose a company vehicle from the dropdown list
- Start Date – choose a date to show transactions entered on or after this date
- End Date – choose an ending date to show purchases made on or before the date
The report itself shows:
- Vehicle ID – the name of the vehicle as listed in the Autos module
- Date – the date of the purchase
- Description – the description as defined by the vehicle driver
- Payee – the name of the company where the driver made the purchase
- Category – the reason the driver made the purchase
- Amount – the total amount of the transaction
- Current Balance – at the bottom of the report displays how much money is remaining in the cash bag
.
.
.
.
Auto Reports optionsThe Options button provides the standard report generation options
- Print – sends the report to the printer using your computer’s print dialogue
- Email – attaches a PDF of the report to a new email using your default email program
- Save – save the report as a PDF to your computer or network
- Close – close the Options window
Export
Exporting the expense report into a spreadsheet program is simple, using the instructions available here: Dashboard > Exporting.
Here is a list of export field names and their field name on the Cash Bag Journal Report. (e.g., field_Name – Field Name)
- autoID – the iPoint identification number for the vehicle (not useful as an exported field)
- category – the Category field from the expense entry
- description – the expense Description
- j_Credit – Dposit entries on the cash bag. This is typically when you give money to the driver
- j_Debit – Payment entries when expenses have been purchased
- payee – the Expense Location where the item was purchased
- transactionDate – the Expense Date as defined on the purchase
- userID – the iPoint identification number for the user (not useful as an exported field)
- Automobiles::easyName – the Name of the vehicle the expense is attributed to
- Globals::REPORTDATEFIELDS – not useful as an exported field
- Globals::REPORTDATEFIELDS – not useful as an exported field
- Globals::URL – not useful as an exported field
Note: any field that starts with an s_ is a summary field and is not useful when exporting to Excel.
Another Note: if you do not include any date or vehicle parameters when running the report, the Cash Bag Journal will report all expenses, even those not attributed with a vehicle.