Cash Book

OrdersTracker lets you maintain your Cash Book to keep track of cash deposits and withdrawals conveniently. All cash payments are entered into the Cash Book as deposit automatically; you do not have to manually enter your orders’ invoices & relevant payment details because OrdersTracker handle that.

You can view all records, search and filter as required, add deposits and also include withdrawals. For offline record keeping, you can download the data into a downloadable MS Excel file.

To learn more about Cash Book, please read below.

1. Tap  in the Top Bar.
   A sidebar menu displays.
2. From the sidebar menu, tap Cash Book.

3. Cash Book screen is displayed. System will automatically display all records for the current date. Each section has been explained in numbers.
   1. Tap on Start Date or End Date to change the date filters.
   2. Another filter option to narrow down the search results.
   3. Total current cash balance is displayed.
   4. Option is available to add deposit or withdrawal details.
   5. Download the search results in Excel format.
   6. List of cash book entries that can be exported

Using Search Filters #

1. By default, records for today i.e., current date are displayed. You can tap on Start Date as per Figure 2 and select desired date. You can also change the Month from the dropdown.
   Once selected, click on OK button to reflect the changes.

2. Another filter option is to select the filter icon as second point in Figure 2. A dialog box appears providing different search criteria’s. Select the desired option and click on the Export button to reflect the changes.

View Details #

In case you want to view more details related to the invoice/record, click anywhere on the data row as shown below. System will show a dialog box on the right side of the screen displaying the details. If the cash book is generated by the system from an invoice, the system will open the invoice details.

Export to Excel #

OrdersTracker lets you download the records of your Cash Book directly to your computer/device in MS Excel format. The process is simple. Click on the Export as Excel button as shown in the image below.

Download will begin automatically and file will be stored on your computer/device in ‘.xlsx’ format. Click on the file name to view the Excel file. Sample format is shown below.

Adding Deposit #

Apart from orders invoices which are automatically added to your Cash Book, you can also add deposits details separately. Entries added will update your current cash balance accordingly.

To add a deposit, follow the steps below.

1. Click on the + Deposit/Withdrawal button as shown in the image.

2. A dialog box appears. Select the first option for Deposit and fill out details such as Date, Reason and Total amount. Once done, click on the Add button to save the record in the system.

Adding Withdrawal #

In case you have taken money out of your Cash Book for expenses such as buying kitchen supplies, paying to courier services etc, you can add withdrawal entries and your current cash balance will be updated accordingly.

To add a withdrawal, follow the steps below.

1. Click on the + Deposit/Withdrawal hyperlink as shown in the image.

2. A dialog box appears. Select the second option for Withdrawal and fill out details such as Date, Reason, Supplier, VAT% and Total amount. Once done, click on the Add button to save the record in the system.