cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
YYC
Level 2

Hi, I have a problem with recording prepaid expenses on Quickbooks Online.

I have been using journal entries to record prepaid expenses.
Scenario:
1 Oct I made a prepayment of R100.
4 Oct I was invoiced for the actual services of R11.50 (including VAT)

On Quickbooks online:
Journal entry 1 (1 Oct):
Dr Prepaid expense 100
Cr Bank 100

Journal entry 2 (4 Oct):
Dr Expense 10
Cr Prepaid Expense 10
[Note: system asks for VAT type next to the journal entries and I chose standard 15%, at the bottom it shows total is R11.5]

When I went to check my VAT report, journal entry 2 is present however the VAT amount is R0.

When I check my prepaid expense balance it shows R90 (instead of R88.50)
1 Comment 1
RaymondJayO
Moderator

Hi, I have a problem with recording prepaid expenses on Quickbooks Online.

Thanks for providing on-point details about your concern, @YYC

 

Creating journal entries for prepaid expenses doesn't include the VAT calculation. This is the reason the VAT report shows R0.00 and your prepaid expense balance displays R90.00

 

To help fix this, you'll have to delete the two journal entries. Then, let's use the Expense feature to make an advance payment worth R100 to your supplier. By doing so, you can effectively manage your supplier balances and tax amounts. 

 

Please first make sure to have the supplier listed in the program. Once done, you can perform the steps below: 

  1. Go to the Plus icon (+) at the upper right. 
  2. Select Expense.
  3. Choose the Payee and the Payment account.
  4. Under the Category column, select Accounts Payable (A/P). 
  5. Enter the description and the R100 amount.
  6. Choose Out of Scope as the VAT type. 
  7. Click Save and close.

The first screenshot below shows you the last five steps.

EnterAnExpense.PNG

 

To learn more about this process, go through this article: How to Record the Advance Payment Made to Suppliers

 

Once done, you can create a bill to record the actual services of R11.50. Just make sure to choose Prepaid expenses as Category. Then, choose Inclusive of Tax in the Amounts are drop-down menu. Also, select Standard 15% as the VAT type. See the second screenshot below for your visual reference. 

EnterABill.PNG

 

After that, go to the Expenses tab and locate the bill. Then, click Make Payment from the Action column (see the third screenshot below). This lets you apply the expense against the bill. Once done, save the transaction. 

MakePayment.PNG

 

You can run the VAT Summary report to see the summary information for each box on your VAT return. This will help you as you complete and submit your return to your VAT agency. For more details about the filing and payment process, visit this article: File and Pay Tax/GST

 

I'll be right here to help if there's anything else you need. See you around and take care always, @YYC