Tag Archives: Singapore

Import journals into accounting software

Software: MoneyWorks accounting software

You need to have type, date, reference, account, description, and amount field in the spreadsheet when preparing an import file for journal transaction.

For journal transaction, use “Jn” for type field. You can either have the type field in the spreadsheet or preset it in the import MAP. The Date is the date of the journal transaction, which you can either have it in the import file or set it in the import MAP as the date of import.

The account field captured the account code, which has to be the same code you used in MoneyWorks. You do not need to have the account name as it will pick up from the system automatically. The journal memo map to the description field of the detail line and the amount field contains both debit and credit value (with a negative for credit).

Import Journal into accounting software

Import the file from the File menu once you have prepared the spreadsheet. Alternatively, you can save the import MAP if you require to import frequently.

Besides importing journals, you can also import transaction such as Invoices, order, payment or receipt transactions. MoneyWorks is a powerful system which helps an accountant ease the daily accounting task. Book a demo today to find out more about how MoneyWorks helps in managing your business finance.

How to add a memo line in Sales Invoice?

Software: MoneyWorks accounting software

Sometime you may want to insert a note before or after an item when preparing an invoice. It could be delivery information for the driver, project information which you want to show in the invoice, or shipping information such as the port of discharge, port of destination, estimated date of arrival, etc.

You may add an asterisk (*) before an item code, link it to a memo income account (to prevent confusion with the actual sales account), and omit the * item from printing on the invoice form. For example:

Item code: *POD
Name: Port of Discharge:
Sales account: Memo income

asterisk item

Then, apply the below formula on those columns which you want to leave it blank when using an * item in the invoice form, columns such as stock code, quantity, unit price, tax code, and the amount.

Formula sample:

if (Detail.StockCode = “*@”, “”, Detail.StockCode)
or
if (Detail.StockCode = “*@”, “”, Detail.UnitPrice)

form design

In this way, only the description column prints the information which you have entered in the detail description column.

Print Invoice

Consult your MoneyWorks consultant if you need help in designing forms.

 

Reference: MoneyWorks User Guide, Form Design.

 

 

Refund an overpayment in QuickBooks

Software: QuickBooks Desktop accounting software

You have an option in QuickBooks Desktop accounting software to offset the overpayment received with the outstanding invoices via set credit feature or refund customer the overpaid amount.

Highlight the outstanding sales invoice from the customer payment transaction, click the Set Credit button and select the credit (overpayment) to offset with the invoice. You have to do the offset process a few times if the overpaid amount is supposed to knock off with multiple invoices.

On the other hand, you need to amend the original customer payment (the overpaid transaction) if you need to create a refund to the customer. At the lower left corner of the customer payment window, select the ‘Refund the amount to the customer’ radio button and click the ‘Save & Close’ button to continue with the refund.

Refund from customer payment in QuickBooks

You will see a payment transaction window on the following page, and then select the relevant bank account, payment mode and change the date if required.

Refund overpayment in QuickBooks.png

QuickBooks will update the accounts receivable and bank account once you have clicked the OK button.

Intuit QuickBooks 2019 is available, contact us if you like to upgrade your QuickBooks.