Tag Archives: QuickBooks desktop accounting software

How to duplicate a template in QuickBooks?

Software: QuickBooks Desktop accounting software

A template is a preset document; a document with your company logo, fields and align according to your business requirement. You can customise template such as invoice, credit note, sales order, etc. from the template wizard under the Lists menu of the QuickBooks accounting system. Besides adding new, duplicate from the existing template is another option to quickly creating a set of templates for your business.

QuickBooks Duplicate Template

Highlight the template, click the template button at the bottom of the template list window and select duplicate to create a duplicate copy. Then, open the duplicated copy and rename or amend the fields accordingly. That’s it, done!

QuickBooks Template Type

QuickBooks 2020 Desktop accounting software is available. Contact us if you like to upgrade.

How to record landing cost in QuickBooks?

Software: QuickBooks Desktop

Advance payment is a payment made to the supplier before goods received. It debits the advance to the supplier account, which is an Other Current Asset and credits the accounts payable. It gets complicated when including the landing cost in the product average cost; often, the landing cost has excluded from the advances made.

Assuming the goods purchased is worth $100,000, and the landing cost is $4,000 (the shipping and insurance). You record the Bill as debits advance to the supplier and credits the accounts payable of $100,000 since no goods have received. Then, do a pay bill when due; the payment debits the accounts payable and credits the bank.

QuickBooks Advance to supplier by account

You can record the $4,000 landing cost via the Enter Bill or Write Cheque method depending on whether any bill received from the forwarder. It debits the landing cost expense and credits the accounts payable when using the Enter Bill, and credits the bank if write cheque method has applied instead.

QuickBooks Frieght charges

A dummy bill has to record in QuickBooks to update the stock on hand when goods received. Select the product with the total cost of $104,000; this amount inclusive of the $4,000 landing cost. Then, deduce the $4,000 landing cost expense and the $100,000 advances paid. This dummy bill:

Debit the inventory assets account 104,000

Credit the landing cost 4,000
Credit advance to the supplier 100,000

QuickBooks dummy bill

There shouldn’t have any outstanding amount unless the advances difference from the billable amount.

The cost of sales will realise when there are sales of the product. It reduces the inventory cost and debits the cost of goods sold when an invoice has added to QuickBooks.

Book a demo today to find out how to use QuickBooks to manage your business finance.

QuickBooks Chart of Accounts

Software: QuickBooks Desktop Accounting Software

The Chart of Accounts in an accounting system is a list of accounts, which categorised into Incomes, Cost of Sales, and Expenses to form the Profit and Loss statement; and Assets, Liabilities, and Equities of the Balance Sheet.

The Accountant has to create the chart according to the organisation requirement and comply with the accounting standard.

QuickBooks Account

The Chart of Accounts is under the Lists menu of the QuickBooks Desktop accounting software. Click the Account button at the bottom of the list window to add, edit, or delete an account. You can also use the ‘Subaccount of’ feature to group accounts; for example, you can group Basic Salary, Bonus, Overtime Pay, and CPF to the Payroll expense account. This ‘subaccount of’ feature allows you to expand or collapse the accounts within the Profit & Loss or Balance Sheet report.

Expand view:

Payroll
– Basic Salary 10,000
– Bonus 5,000
– Overtime Pay 3,000
– CPF 3,600

 

Collapse view:

Payroll 21,600

For those who prefer to work with an account number, it can be turned on from the Preferences (under the Edit menu). QuickBooks account number support up to 7 characters, which should be sufficient for most of the small businesses. However, you should not use account number feature if your computer has turned on non-English languages such as Chinese, Japanese, Thai, etc. For example, a ‘?’ will be inserted between the account number and account name, and cause an error when the Chinese language has turned on.

Consult your accountant if you have a problem in organising the Chart of Accounts.

Sign up a free QuickBooks demo to find out more on how to use QuickBooks to manage your business finance.