Category Archives: QuickBooks 2011

QuickBooks | GST on imported goods

Software: Intuit QuickBooks accounting software

The foreign vendor, which you imported goods from, is not a GST register trader; hence they will not indicate the GST on their bill.

However, when the goods arrived Singapore, you are required to pay the GST at the Custom (Sometime the forwarder may pay the GST on behalf of you).

Assuming the GST (7%) paid is $7,571.76 (that is based on an imported value of $108,168.00). You may use a Write Cheque transaction to record this payment.

The first line under the expense tab is $108,168.00 with 7% rated GST, and the second line will be a negative value of $108,168.00 without any GST associated. This is to contra off the value in the Cost of Goods Sold account.

QuickBooks - Write Cheque

The double entry for this transaction is:

Debit Cost of Goods Sold: 108,168.00

Credit Cost of Goods Sold: 108,168.00

Debit GST Payable: 7,571.76

Credit: Bank: 7,571.76

The Cost of Goods Sold account is a dummy account which you use to indicate the purchase value, you may consider to use a different account such as GST expense account.

This will also update the Tax report, under the Tax on Purchase section. $108,168.00 will be the taxable purchase and $7,571.76 is the input tax value.

 

 

Separate the Sundry Creditor from Trade Creditor

Software: Intuit QuickBooks accounting software

To simplify the data entry, by default, QuickBooks is using an Accounts Payable account to track all the Bills received.

However, some accountant may prefer to separate the Sundry Creditor from the Trade Creditor when printing the Accounts Payable Ageing report.

You can use the Vendor type to segregate the vendors. You may add vendor type such as Sundry and Trade, then set the sundry creditor with Sundry vendor type and trade creditor with Trade vendor type.

QuickBooks - Vendor Type

The vendor type will not affect the data entry nor the account.

When printing the Accounts Payable Ageing report, you can filter the Vendor Type by show only the Sundry or Trade vendor type.

QuickBooks - Filter ageing report

This will separate the Accounts Payable into two separate reports, one for the Sundry and the other for Trade.

QuickBooks - Ageing report

QuickBooks | The walking ATM

Software: Intuit QuickBooks accounting software

You may give your purchaser a sum of money to go overseas to source for new products, make payment and arrange shipment back to your country. Your purchaser is like a “walking” ATM (Automated Teller Machine), help making payment as and when required.

You may create this “Purchaser” as a Bank account type with the currency type set up accordingly. That is, if you are paying him/her in CNY (Chinese Yuan Renminbi), then the currency type will be in CNY.

You can use General Journal, Transfer Funds or Write Cheque method to transfer the fund to him/her. If Write Cheque method were to be used, then you need to create a name (either Vendor type or Other Name type) with the currency type set up to be same as the currency transacted (that is, CNY if payment to him/her is in CNY).

The double entry for this transaction will be:

Debit the Purchaser’s account (Bank account type)

Credit Bank account (The bank account which you transferred the money from)

When payment made by the purchaser, you may use the Write Cheque transaction to issue out payment from the Purchaser’s account to the “Vendor” with the corresponding account settings, such as Cost of Goods Sold account or relevant Expenses account) under the Expenses tab.

The double entry for this transaction will be:

Debit Expenses (or Cost of Goods Sold) account

Credit Purchaser’s account (Bank account type).

You can use the Cheque Register to view the transactions and the balances of this account (From the Banking menu select Use Register).

The advantages of using a “Bank” account type for tracking of the advances paid to the purchaser is that you can use the “Reconciliation” function in QuickBooks to tally up the account.

Any positive amount left in this Purchaser account, which can be viewed from either the Register or the Balance Sheet report, will be the amount due by the purchaser to the company.

If the Purchaser returns the money to the company, you may use a General Journal, Write Cheque or Transfer Fund’s method to transfer the money back from the Purchaser’s account to the bank account.

The double entry for this transaction will be:

Debit Bank account (or Cash in Hand account)

Credit Purchaser account.