Cash Bag JournalCash Bag Journal

The 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 optionsAuto Reports options

The 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


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_NameField 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_CreditDposit entries on the cash bag. This is typically when you give money to the driver
  • j_DebitPayment 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.

iPoint Version: 9.05
Last modified: 13 Sep 2021

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.