Category Archives: QuickBooks Asia

Invoice in multiple currencies

Software: QuickBooks Desktop Accounting Software

You can record bill or issue invoice in foreign currency once you have set up to use the multiple currencies feature in QuickBooks.

A currency has to tag to each name set up in QuickBooks. For example, you tag USD to Customer A if you trade with him in USD and invoices issued will link to the USD Accounts Receivable account automatically.

QuickBooks - Multiple Currencies

Multiple Customer A has to be created if you are trading with him in multiple currencies. For example, you create two names in Customer Centre if Customer A buys from you in both USD and MYR. One set as USD and another in MYR. QuickBooks treats them as a separate entity and will both show in the receivable report separately.

 

Contra QuickBooks’ Credit Memo with Sales Invoices

Software: Intuit QuickBooks Desktop accounting software

Credit Memo (aka Credit Note or Adjustment Note) is an accounting document given by the seller to the buyer for goods or services returned. A refund of the credit amount can be given or offset against the future purchase.

Use the “Create Credit Memo/Refund” feature in QuickBooks to record the return of goods/services from a customer. QuickBooks gives the user an option to retain as an available credit to offset against the future purchase, give a refund immediately, or apply to an invoice when the credit memo saved. Among the three options, “Retain as an available credit” is most commonly used.

quickbooks-credit-memo

“Retain as an available credit” is use to contra the credit memo against the future purchases. Let’s say you have issued a credit memo and some invoices for a customer. When making payment, the customer can opt to apply the credit memo to the outstanding sales invoices. In the QuickBooks’ Receive Payment transaction, click the “Discount & Credit” button after you have highlighted the sales invoice and apply the credit memo to an invoice accordingly.

Join my QuickBooks training class to explore how QuickBooks can help in your business.

Define Fields in QuickBooks Desktop accounting software

Software: Intuit QuickBooks Desktop Accounting Software
Data field is a place, a container, in a database which stores information. For example, when recording a contact in QuickBooks, the Company, Phone, Address, etc. are data fields.

QuickBooks allows the user to define up to 7 Custom Fields in Name (Customer, Vendor, and Employee) and 5 in the item (The item such as Inventory, Service, Inventory Assembly, etc.). You can insert the Name’s Custom Fields in the Header section of an invoice form and the Item’s Custom Field in column section of the template. The Custom Fields are non-calculative, it is a text field for inputting static information.

define-fields

For example, you require a field to capture since when the contact starts buying from you. You may add a Custom Field in the Name and label it as “Customer Since”. Whenever you create a customer, add the date in it. You can use the Custom Field in the item to capture information such as size, colour, product measurement, etc.

Besides inserting the custom field into a template, you can pull it out to the relevant reports or use it in the Find function.

Although QuickBooks has limited custom fields available, it should be enough for most of the small businesses to manage their accounts.