Category Archives: Accounting

Refund an overpayment in QuickBooks

Posted on December 6, 2018 | Leave a comment

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.

Print page number on the report

Posted on December 5, 2018 | Leave a comment

Software: MoneyWorks accounting software

By default, MoneyWorks product name and page number print at the report footer when the print page option has selected during printing, such as ‘MoneyWorks Gold – Page 1″ if you are using MoneyWorks Gold. You cannot remove the product name from the option, but you can customise the report if you prefer not to show ‘MoneyWorks Gold’ in front of the page number.

Default page number

Unlike custom template, which the page field is available in the form designer. To customise the report, add a Remark row at the top of the report. Then, use a cell within the Remarks row (for calculation purpose) and enter:

ident: pagenum
value: =0
Format: 0,-0

pagenum field

Note: ‘pagenum’ is a field name, you can replace with any preferred name.

Next, at the bottom of the report, add a Heading row after the Page Break row (or before the last End If row of the Ledger report) and set it as Running Footer, and then enter the formula in a Cell (your preferred location) within the row:

ident: pagenum
value: = pagenum+1
Format: 0,-0

If you prefer to print as Page 1 instead of 1 alone, then add a “page” text in a cell before the pagenum cell or add a username field if you want to print the name of the user who has prepared the report.

page number

Save the custom report in the Custom Plug-ins folder and remember to sign (give access right) and upload to the Datacentre server or MoneyWorks Now (Cloud-based MoneyWorks accounting software) if you are in a multi-user environment.

Contact your MoneyWorks consultant if you have a problem customising the report.

Currency name versus currency code

Posted on December 4, 2018 | Leave a comment

Software: MoneyWorks accounting software

When adding a Transaction.currency field into the sales invoice or receipt template, it prints the currency code used in the transaction. For example, to print an invoice total of US$1,000, you use:

Transaction.currency+Transaction.gross

The invoice total prints as ‘USD1,000.00’.

On the other hand, it may be more appropriate to show the currency name instead of the currency code when converting the invoice total in English. That is, print the invoice total as ‘US Dollar One thousand dollar only’ is better than showing the currency code ‘USD’.

The currency name, such as ‘US Dollar’, stores in the Off-ledger table, which require to use a Lookup function

Lookup (Transaction.currency, “Offledger.description”)

to pull out the currency name.

It prints as ‘US Dollar One thousand dollar only’ when adding the formula in front of the DollarsToEnglish ( ) function of the Transaction.gross.

Lookup (Transaction.currency, “Offledger.description”) + ” ” + DollarsToEnglish (Transaction.gross)

template design