Excel data to Account Right

Question

I have a excel sheet which we compile data each month to invoice to a client. Is there a way to export this data to MYOB so it generates an invoice per row, rather than me having to manually enter each invoice manually.

The sheet contains multiple columns of data which needs to be invocied and each row reflects a new invoice.

Is there any way to do this with MYOB to help reduce invoicing time. ? We use AccountRight.

I am just trying to find a faster way to do this invoicing as it is very time consuming.

Thank you.

mark_humphreys · Answer

Hi&nbsp;nikki_82&nbsp;You need&nbsp;The simplest way to connect MYOB and Xero with Power BI and Excel - OdataLink&nbsp;Contact&nbsp;jeff@accountingaddons.com.au for futher info.&nbsp;RegardsMark&nbsp;&nbsp;&nbsp;

sean_dc · Answer

Hi nikki_82&nbsp;Thank you for your post. There is another way to import your invoices as well to AccountRight, which is by clicking File &gt;&gt; Import Export Assistant. You can first export Sales so you can get a template so that you can upload your Excel sheets properly. It would only export you a .txt file, but this can be converted into a CSV file. Most Excel has the option to import .txt. After that, you can now enter your data and import it to AccountRight.&nbsp;This Help Article, Importing Data, has more information on this that you can use as your guide for importing and exporting.
&nbsp;
&nbsp;
Please feel free to post again. I'm happy to assist further.
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users in finding this information.
&nbsp;

Forum Discussion

Excel data to Account Right

2 Replies

Looking for something else?

Related content

Can't export reports to Excel

Exporting reports to excel

Connected Accounts

Connected Accounts - Getting Started

Unable to Export Reports to Excel

Export to Excel and send Excel file not working

AccountRight not exporting to Excel

Excel 2024 and MYOB