Posting a batch of sales invoices

Question

Is it possible to post a batch of invoices in AccountRight Plus. I have around 300 invoices to produce and post for a few line items? Do I have to do them individually?&nbsp;

komal_s · Accepted Answer

Hi&nbsp;SharonMaguire&nbsp;The invoice numbers should auto generate if the import template has all the data entered correctly. Please try it and let me know how you go on.&nbsp;

sharonmaguire · Answer

Hi MaureenThere is a sample in the sample company that you can export, see below snip with how to find it.I actually can't open it now so maybe it's broken.The other way is enter a similar sales invoice that you want to import in a batch and export this from the the import/export assistant and use this as your template.Hope that helps&nbsp;

komal_s · Answer

Hi&nbsp;SharonMaguire&nbsp;If you have the invoices in a third party programme or Excel, you can use the Import/Export Assistant to import them in bulk in the AccountRight. Another alternative would be creating one sales invoice, saving it as recurring and then&nbsp; using that recurring transaction to create other invoices.
Let me know if you have further questions on this.&nbsp;

sharonmaguire · Answer

Hi KomalThank you, I found the export template for import. I'm assuming if I leave the Sales Invoice No column blank, MYOB will auto generate them.

sharonmaguire · Answer

Hi&nbsp;I'm now getting Error 25 but not sure why, also the column Inc Tax Total can't be matched as it's not an available field. I also have a ship to in this import as we have header accounts with student accounts attached. See files.

komal_s · Answer

Hi&nbsp;SharonMaguire&nbsp;
The import can fail with this error message if the amount calculated in the import file is not correct with respect to the tax code and values.
&nbsp;
To check why the import is failing in this specific situation, can you please enter one sales transaction in the software, export it out, and then import it back again? If it fails, please try switching between tax-exclusive and inclusive options and also try using different amounts to rule out any rounding-related errors. In addition to that, please also ensure there are no special characters like&nbsp;$&nbsp;or&nbsp;" "&nbsp;around the amount values in all the amount columns in the import file.&nbsp;
&nbsp;
Let us know if the issue still persists so we can investigate further.&nbsp;

Forum Discussion

Posting a batch of sales invoices

7 Replies

Related content

Helpful post has been hidden

Error 4346 An unbalanced transaction Sales Invoice Batch Import

Reconcile a batched electronic payment in bank feed

API Question - POST Item

How to edit a processed electronic payment batch

Electronic Payment Batch

Posting an inheritance

Error posting journal in NZ payroll 2023.1