Contents
- Index
Income & Expense Reports
This screen is accessed from the
button on the Income & Expenses screen.
Screen Layout
This screen is used to provide reports for the income and expenses entered. Reports are limited to the date range provided at the top of the screen. Use the buttons immediately underneath the date range to set the date range to the setting on the button.
You may also limit your display using the controls in the "Limit Data Shown To:" box. This is initially set to "No Limits (Everything)." You may further limit the display to:
Truck (No Loads). For the current truck, it will show you the overall records for that truck only that are NOT tied to any specific load. Use the
Truck button to select a different truck.
Truck + Loads. This will show all records for the truck, plus any loads for that truck.
Load Only. This will show you the entries made for the indicated load only. Use the
Load button to switch to a different load.
Overhead Only. This will show you only those entries that are not associated with a truck/load.
Truck (Loads Only). For the current truck, it will show you only the records that are tied to loads.
You may limit the report to a specific tax year.
You may limit the report to only income entries, or only expense entries.
You may limit the report to specific categories.
You may include or not include those categories that are marked as "Do Not Include in Tallies" in category maintenance.
Running a Report
To run a report, select the desired report listed under "Reports Available." Then, click one of the three buttons to the right:
This will preview the report.
This will send the report directly to your printer.
This will send the report as a PDF attachment to an e-mail. See the e-mail send screen for more details.
Exporting
Follow the same steps for creating a report (as far as date range and the "Limit Data Reported To:" are concerned). Then, click the Export Income & Expense as CSV button.
This export will create a comma separated value file with the following layout:
Truck Number
Load Number
Year
Month
Day
Date (formatted as mm/dd/yyyy)
Category
Description
Amount
How Paid Type
How Paid Code
Memo
Tax Year
Reimbursable (Y or N)
Reimbursable Amount
Settlement Number
I or E for Income or Expense
Amount (signed). Income will be negative and expenses will be positive.
Income only
Income only (signed)
Expense only
Text fields will be wrapped in double quotes. Any embedded double quotes will be replaced with a space.