Tip: Generating recurring invoicing via JIBE
Is part of your business processes to generate reccuring invoicing from a job?
A good example of this is if you have a contract to provide a service to a client, and you will bill them a certain amount for this service each month regardless of your costs that month.
It can be a time consuming process to generate these recurring invoices each month.
JIBE (Job Batch Invoice Engine) is an Exosoft Add-On Product for MYOB Exo, and has the ability to allow users to generate quote lines to costs for invoicing against multiple jobs at once and then invoice multiple jobs at once based on the quote lines cost group.
This tip of the week will take you through enabling recurring invoicing in JIBE and how this could be managed for your business.
JIBE is an additional application, once the JIBE install has been run across your Exo database by a software consultant there is the ability to enable “Recurring Transactions” within this application.
Options > Settings > Enable Recurring Transactions > Then tick on the cost group(s) that define the recurring invoicing in your business.
In the below example, we have created an additional cost group “Monthly Fee” which has been enabled as the recurring transactions identifier.
Once this is enabled, ensure your quote line(s) that you would like to generate are set to this cost group and the copy to field is set to “C” as per below:
You can then open the JIBE application, and select the applicable job status (or all job statuses if these recurring transactions could be against different job statuses).
Right click in the job statuses column “select all” (if you wish to select all job statuses), then click generate as per below:
Select the billing date for the transaction(s) you are going to generate
This will display a preview of all the transactions that meet the selected criteria (job status, type, categories selected, with a quote line that is set to copy to “c” and also is assigned against a cost group defined in JIBE settings to be a recurring transaction cost group).
You can right click on the column header and pull in any fields that are applicable to you and arrange the fields in your preferred view or filter on the data by the filter column in the header.
Once you are happy with the data that is displayed (transactions that are going to be generated) click Generate and Yes as per below:
This Process moves all the quote lines to the costs tab of applicable jobs with the transaction date you specified as per below:
You can then “bulk invoice” these jobs in the JIBE application again by selecting the applicable job statuses, types and categories.
Ensure you have “Ready to Invoice or Work in Progress” selected as the job line status and click “Start” as per below:
This will pull through ALL transactions sitting against jobs that match the search criteria with a line status of “Ready to Invoice” or “Work in progress”.
In the below example, I have filtered it to only be the jobs I generated transactions for above.
I can then hold down Ctrl and select all jobs that I wish to update cost line statuses for; these will turn selected jobs blue to indicate they have been selected.
Right click, “Set lines as” and select the line status you wish to send these to (in this case “ready to invoice” as per below:
The below pop up will appear, select Yes.
Then select the jobs you wish to invoice, there is a right click option to select all or deselect all, then click “Invoice checked jobs”
Below will appear as it is recommended that you backup you Exo database prior to bulk invoicing incase you bulk invoice incorrectly and require the ability to revert back to prior to the bulk invoicing.
If you click yes, you need to specify a UNC path where the backup file can be located.
You will then get the below screen where you can bulk update the job status, due date or set an invoice narrative across all the jobs you are invoicing:
As per below, this will go through and generate invoices against the jobs specified, you can click print to print an overview of all the invoices you have generated if required.
We then recommend using the bulk batch invoice engine in MYOB Exo to email/ print the invoices that have been generated via JIBE.
If you were to complete the same generate function and select the same billing period (month) as per below:
In the generate screen, lines will display in red and show a warning message advising that the transactions had already been generated as a flag to end users that these transactions have already been generated for the month.
If you have any further questions please contact the Exosoft team via email: [email protected] or phone NZ: 0800 12 00 99 AU: 1800 60 80 77