Software: MoneyWorks v6 accounting software
Importing transaction, such as Sales Invoices, into MoneyWorks is not as difficult as some of the user may think (Refer to your MoneyWorks manual Page G-349 for detail on Importing & Exporting).
I have a spread sheet consist of Invoice Date, Type (Type of transaction; DI is Sales Invoice and CI is Purchase Invoice), Stock code, quantity sold, Customer name and customer code. I am going to import this information into MoneyWorks.
Launch your MoneyWorks, go to File menu, select Import then follow by Transactions. A Mapping window will show, which allow you to map your fields according. In this case, since I do not know the value for Invoice number, Unit price, gross amount and so for; I let the systems to pick it up from the MoneyWorks data file by changing the “Use Value” to “Work it out”; that is, let MoneyWorks work it out for me.
Since this information is going into one single invoice with multiple line items, you can click the Options button and select the radio button for “Transactions are split over multiple lines of text” and set a Key field to link up these line item (In this case, I am using “ToFrom” field).
Save your Map for future use, click on Import button to start importing the transactions.
Here is the imported invoice: