Tag Archives: QuickBooks Online

How to record the GST paid on your behalf by the forwarder in QuickBooks?

The non-GST registered overseas supplier will not be billing you GST for the goods imported, but you have to pay the GST directly to the Custom or the forwarder if they paid on your behalf.

Assuming the bill received is S$100,000.00. You enter the Bill into QuickBooks Online (QBO) as debiting the cost of goods sold and crediting the accounts payable with NR (non-registered trader) or OP (out-of-scope purchase) GST code. Note: It debits the inventory assets instead of the cost of goods sold if you are using the inventory feature in QuickBooks.

Enter Bill in QuickBooks

Let’s say the forwarder billed you:

  • Transport/Trucking/Storage charges: $5,800.00
  • Custom clearance charges: $150.00
  • Custom documentation fee: $30.00
  • 7% GST (paid on behalf): $7,000.00

Subtotal: $12,980.00
GST 7% (on $5,800): $406.00
Amount due: $13,386.00

The $7000 is the GST paid on your behalf, whereas the $406 is the GST for the forwarding services.

So, you record the forwarder bill into QBO as:

  • Row 1: Freight Charges: 5,800.00 (7% GST)
  • Row 2: Freight Charges: 150.00 (OP GST Code)
  • Row 3: Freight Charges: 30.00 (OP GST Code)
  • Row 4: Cost of Goods Sold: 100,000.00 (with 7% GST)
  • Row 5: Cost of Goods Sold: -100,000.00 (OP GST Code)
Enter Bill in QuickBooks

Note: 

  1. Row 4 indicates the taxable amount of $100,000 for the $7000 GST paid, which will show in the GST Form 5 report.
  2. Row 5 is a reverse of the taxable amount of $100,000 from the cost of goods sold since the actual purchase has already been recorded (Supplier Bill).

GST Form 5 box number 7, input tax and refund claims:

QuickBooks GST Report

Exchange rate

The taxable amount in the Singapore dollar is converted based on the Custom exchange rate, which may be different from your system exchange rate. Therefore, the taxable amount (Singapore dollar equivalent) in the forwarder bill may not be the same as the supplier bill you entered earlier. You claim according to what you have paid.

QuickBooks Online (QBO) is a cloud-based accounting system. It uses a web browser to access your company file without the software installed on your computer. You may contact us if you wish to switch to QBO from QuickBooks Desktop or Reckon Accounts.

Switch over to QuickBooks Online

Simple, but yet could be challenging for some.

Switching over to new software, often, get overwhelmed by the rich features available; confused and wouldn’t know where to start.

Although QuickBooks Online (QBO) is a cloud-based accounting system, suppose to be easy to use, it may still be challenging for some. After entering the company name and selected the industry on the welcome page, what’s next?

Where to customise the invoice template, create the chart of accounts, update the products and services list, import the customer and supplier names, how to record the opening balances, etc.

Of course, help is readily available. There are QBO help articles and videos available on the official Intuit channel and non-official channel by blogger and YouTuber over the world. That’s the beauty of the World Wide Web; isn’t it?

Besides, you can also engage a QuickBooks consultant if you are still not comfortable, help you implement and shorten the learning curve. 

Here are a few steps for you to kickstart if you prefer to DIY (Do-it-yourself), set up your business finance in QBO.

QBO Gear icon

Gear icon. The gear icon will be the very first icon you click when using QBO. You need to set up your company preferences, such as the company address, insert logo, set up home currency (if you are using multiple currencies) and the first month of your financial year started from the accounts and settings page. Then, create the chart of accounts and update the products and services list; which you can find these lists under the gear icon too.

QuickBooks Online +New icon

+New icon is the place where you can find all the daily transactions such as invoice, receive payment, bill, cheque, journal entry, etc. It’s the most often visited area when using QuickBooks Online. Besides daily transactions, you record the opening balances, if any, via these transactions too.

QuickBooks is a form-based accounting system. Once you click on the save and close after creating an invoice, the system debit the accounts receivable and credit the sales automatically without needing to post a sales journal separately. The invoice emailed to your client automatically once you opt for online delivering sales form from the accounts and settings page.

QBO Search function

Oops! You make a mistake. Don’t worry. Go to the search bar located at the top of the page, click on it, and you can find your recent transaction. As long as you are authorised to change, you can edit and save the amended transaction.

QuickBooks Online navigator

The transactions which you have recorded registered in the transaction list. For example, the invoice and receipt capture in the All Sales list of the Sales Navigator, and the Bills and Cheque is under the Expenses list of the Expenses Navigator.

Go to Report Navigator, where you can find all the relevant reports to cross-check what you have recorded in your book.

Once you understand the flow of using QBO, you can try connecting your bank account to the bank. Pull down the bank transactions automatically into QBO to match or add into your book, and prepare your reconciliation.

Using QuickBooks is not difficult if you have set up correctly. QBO is country-specific, which has its GST or VAT set up, subscribe to QBO Singapore version if you are using it for Singapore business account. Contact the local office or consultant if you have doubts.

The three main things you need to know to kicks start your business finance in QBO:

  • the Gear icon to set up your preferences and lists
  • the +New icon to record your daily transactions
  • and find the transactions and reports from the navigator located at the left panel.

Easy?

Hope these are helpful for you to kickstart your book in QuickBooks Online.

For existing QuickBooks user in Singapore who intend to switch from Desktop to QuickBooks Online may contact us. It’s good to sign up a demo to see the differences between QuickBooks Desktop and QuickBooks Online before you dive into a new piece of software.

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.