CASH BOOK REPORTS

Purchase By Items Summary Report (1)

CASH BOOK REPORTS

A cash book is a financial journal that contains all cash receipts and disbursements, including bank deposits and withdrawals. Entries in the cash book are then posted into the general ledger.

KEY TAKEAWAYS
  • A cash book is a subsidiary to the general ledger in which all cash transactions during a period are recorded.
  • The cash book is recorded in chronological order, and the balance is updated and verified continuously.
  • In ACCOXI CASH BOOK reports can be accessed from report modules and by selecting accounts.

Cash Book Reports

FIELDS

DESCRIPTION

Customize report

Users can filter the report data using the customize report option. The reports can filter between dates. Then by clicking the run report and the user will get the filtered details of the report.

#

Serial number of the data included in the table.

Transaction date

The date of the transaction is visible  in this column

Ref no.

The reference number of the cash transaction is shown here.

Accounts involved

Accounts involved in a particular transaction is shown here. And there is a cash book drill down option is available where the user can view the corresponding transaction by clicking the accounts involved column.

Narration

The narration of the transaction is shown in this column.

Debit

The amount debited to a particular ledgers are shown here

Credit

The amount credited to a particular ledgers are shown here

Print

Users can print the reports in the reports module by clicking the print button user will be redirected to the report view menu where the user can print the reports and the user can also export the report data into an excel sheet, pdf file etc

Exit

Users can close the aging details reports window by clicking the exit button.

Options available in print report menu:

Printview.

1.Page setup option bar:

User can adjust the page view using the page setup option bar.

  • Users can refresh the page to update any changes made.
  • Users can navigate the page using the first page, previous page, next page and the last page
  • And it also shows the current page number and the total number of pages of the report.
  • And by giving page number in the current page number box and pressing enter. It jumps to the said page.
  • The page setup button allows the user to define the paper size, orientation and margins of the report.
  • User can switch between interactive layout and print preview layout using the switch button
  • The adjustment of the zoom size of the report is also available in the page setup bar.

2.Print: Users can print the reports in the reports module by clicking the print button user will be redirected to print setup window where the user can adjust the print options. options.

Frequently Asked Questions?

01How can I take printout of Cash book report?

  • Click on the Reports module.
  • Select the report Cash book under Accounts head.
  • At the right hand side of the report, there is a Print menu.
  • Click on the Print menu and it opens the print view form.
  • You can set the page range, page height, width and can enter the required number of copies here.
  • Click on the Print menu to get the printout of the report.

02Can I filter the Cash book report? How can I do it?

Yes. You can filter the report by using the option Customize Report. By clicking on the customize report, can filter the report as on selected date.

  • Click on the Reports module.
  • Select the report Cash book under Accounts head.
  • Click on the Customize Report menu.
  • By clicking on the customize report, you can filter the report by selecting a date. Select the required starting date along with the end date to filter the data.
  • Click on Run Report to get the customize data.

03Is it possible to access the Ledger details of Accounts? How can I do it in Cash book report?

Yes. You can access the Ledger details of the accounts involved column by using the drill down option.

To view the  ledger details of transaction, click on the accounts involved field. While clicking on the field, it opens to the ledger report of the selected account.

04How can I export data in to Excel format?

  • Click on the Reports module.
  • Select the report Cash book under Accounts head.
  • At the right hand side of the report, there is a Print menu.
  • Click on the Print menu and it opens the print view form.
  • Click on the Export menu at the bottom right side of the page.
  • New tab will appear for save the file. You can select the location to save the file.
  • Click on save button to save the data in Excel format.