This is Level 6- 7 Feature

To generate the data needed for the Cash Reserves Report, begin: here

Cash Reserves Report Screen

When the data generation process is complete, you will be moved to the Cash Reserves Report screen.  The report will be summarized in spreadsheet form.  The spreadsheet includes the date, time, and the number of reports processed as shown below:

Here's an explanation of each of the features found on the above screen:

Total Units Sold. This is total number of units sold.  For example, in the case of books, it's the total number of books sold for all royalty reports covered.

Total Sales. This is the sum total of the sales for all of the units sold.

Grand Total Figure. The Grand Total figure is the most important figure on the report.  This is the total amount of royalties your business owes to its royalty holders for the selected time period.  If you are running a monthly cash reserves report, this figure tells you how much you need to keep in reserve to pay the royalties.

Log File. The final column in the report is the name of the log file associated with the report.  It's a handy addition to the main report.  You can view the log file by clicking on the "View Log File" button.  This will start your spreadsheet program and display the log file.  The spreadsheet summarizes each of the reports making up the totals in the Cash Reserves Report.

Important Note for Network Users: Log files are created on the local computer and are saved in the C:\AnyBook\LogFiles directory.  In other words, log files are only accessible to the computer on which you are working.  If you use log files, it's best to work from only one computer on the network.  If you need to work from other computers on the network and must access one or more log files, you will need to copy the files that you need to the computer on which you are working.

Calculation Features. "Calculate Total for the Year" is useful feature for those that utilize the calendar year for their fiscal year.  Select one of the rows in the spreadsheet.  AnyBook looks at the year of the start date of the currently select row.  It will then add up all reports that have the same start year.  To effectively use this feature, you need to make sure that you don't have any duplicates and the reports with the same start year cover a twelve month period.

The "Calculate" button is more flexible when it comes to totaling several rows on the spreadsheet.  In this case, you select what reports you want included in the report.  To select reports, hold down the CTRL key and click on the reports you want.  Each report to be included in the calculations will be highlighted.

When you have the reports highlighted, click on "Calculate."  AnyBook will provide the totals.

View/Print in Spreadsheet. The "View/Print in Spreadsheet" moves the data from Cash Reserves Report to your spreadsheet program.  That allows you to arrange and format the data for a printed report.

Delete Button. Use the "Delete" button this to remove old or duplicate reports.  Select the row to be deleted and click on "Delete."