Cash Flow
- If you are looking at creating a future cash flow report, then consider the Revenue Report that is available on the 'Reports' menu in RentalPoint? Although this report may not show all the custom fields you are looking for, it does give the basic dollar values and can be grouped by status of the booking.
- In Version 10.1 of RentalPoint there was an option added which allows you to run a Profit Analysis Report for more than just one booking at a time. In earlier versions you can use the profit analysis button inside a booking (at the bottom of the equipment tab page) to give you a profit analysis for that booking. In Version 10.1 this was extended so that you can run a Profit Analysis Report for a period of time (the next 120 days as an example) or for a list of bookings and have the information come out in various different types. Click here for more information
- If this does not work for you, then there are two other ways of achieving what you want to do. The first is via a custom Crystal Report template that we can write for you or you can write yourself if you own a copy of Crystal Reports and know how to use it. For this option if you make an excel mock up of the information you what shown and in what layout you want to see it, using this information we can provide a quote to create the custom crystal report template for you. This option is great if you want to be able to enter some dates into a window and then have the report run based upon those dates and group / order the data in a particular way. It can also summarize the information and display graphs as well if you would like it to.
- Another option is to pull the information straight into Excel, and this works well if you don't want to keep changing the dates you want to run the report for. For example if the report was to run for the current month plus 3 months, then this would work very well. Also with this option you get the raw information out, but would need to add columns up manually. This normally isn't an issue if the report are run adhoc but if it is a report that is run every month or every two weeks or such like, then adding formulas each time to the excel file is time consuming. In this case the Crystal Report is usually better as you run the report for the time period you want and then it displays it in a final and formatted way, with totals, summaries, etc. you still have the option to export it to Excel, PDF or print it as required.