QuickBooks HelpQuickBooksHelpIntuit

Record VAT-only and CIS transactions in QuickBooks

by Intuit•21• Updated 3 days ago

There may be times when you need to record a transaction that includes VAT only or log a CIS payment to HMRC. Learn how to do both accurately, so your VAT returns and reports stay up to date.

Record a VAT-only or 100% VAT transaction

You can record a VAT-only transaction using an expense or by adjusting your VAT return directly. Choose the method that best suits your reporting and reconciliation needs.

Use this method if you want the transaction to show in your supplier list, reports, and bank feed.

  1. Follow this link to complete the steps in product Open this link in a new window
  2. From the New Transaction dropdown, select Expense.
  3. Select a payee, or leave it blank if not needed.

On the first line:

  • Choose any Payment account.
  • In the Amount field, enter the VAT exclusive amount (e.g. 1,500).
  • Select 20.0% S as the VAT code.

On the second line:

  • Enter the same amount as a negative (e.g. -1,500).
  • Select Exempt as the VAT code.
  1. The total should now be ÂŁ0, with VAT appearing in the VAT section.
  2. If needed, manually edit the VAT box to reflect the correct amount.
  3. Save the expense.

This will create a VAT-only transaction that appears in Box 4 of your VAT return.

If you only need to adjust the VAT return and don’t need a corresponding supplier or bank transaction, use this method.

  1. Follow this link to complete the steps in product Open this link in a new window
  2. Under the Action column, choose Prepare return.
  3. Next to Box 1 or Box 4, select Adjust.
  4. Enter the date of the transaction.
  5. Choose the relevant VAT code and the account used for the adjustment.
  6. Enter the amount.
  7. Add a memo or note for reference.
  8. Select Save.

Important notes:

  • This method does not create a supplier transaction.
  • It will not match to your bank feed – you’ll need to manually exclude and reconcile any related transaction.
  • The adjustment won’t appear in the supplier list. To find or delete it later, go to the account history or use a report.

Record a CIS payment made to HMRC

After submitting your CIS return, it’s important to record the payment made to HMRC. This ensures your CIS reports and bank feed stay accurate and aligned.

  1. Follow this link to complete the steps in product Open this link in a new window
  2. From the New Transaction dropdown, select Expense.
  3. In the Payee field, enter HMRC (if you’ve set them up as a supplier).
  4. Choose the bank account and payment method.
  5. Set the payment date.
  6. Under the Category column, select CIS payable to HMRC.
  7. Enter the amount paid.
  8. Select Save and close.

Tip: Match your bank transactions before running CIS reports to ensure everything lines up.

QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start