Reply to topic

Vat/ GST NZ Tax Report Generating - How to?

Abonz411
Registered Member
Posts
3
Karma
0
Hi everyone. I’m using Linux Mint 17.1 with KMy Money 4.6.4 for our home business and need to account for Goods and Services Tax once a month in New Zealand here.
However I'm struggling with customising the report to show all items that I have bought for the business that have paid GST/Vat on so that I can lodge a claim. Sound easy... however I’m not getting any data from it at all!

If you can help then please get in touch. Thanks
crun
Registered Member
Posts
8
Karma
1
I am just trying to set up, and battling the same thing. I am using latest appimage (5.08) from kmymoney downloads.
See also https://forum.kde.org/viewtopic.php?f=69&t=94196
This is how I am going so far:

Make a new category in Expenses. (Repeat the same idea in Income)
"GST Paid"
on "TAX tab" tick "VAT category" and set 15%

Make a new category in Expenses
"Vehicle"
on "TAX tab" tick "Enable auto VAT assignment" and select "GST Paid" and "Gross"
So now it to will split 15% from any "Vehicle" expenses WHEN YOU EDIT THE TRANSACTION
[What do those buttons "All" "income" "Expense" "None" do??]
[Does tax nest down the categories??]

Go to a transaction, "Edit" set category to "Vehicle" and "Enter"
For existing transactions, select it (you can multiselect them all) press "Edit" then "Enter" and they will change to split.

someone says to make sure "show in tax reports" is checked. I have yet to explore how they will work

Annoyingly they all show "Split Transaction" as the category now. WTF?
User avatar ipwizard
KDE Developer
Posts
928
Karma
4
OS
I am in a similar position having to provide tax reports about goods and services. Here's what I did:
  1. Setup the categories as you did. That is perfectly OK.
  2. Take a Transactions by category report as a base
  3. Select all income and expense categories for which VAT/GST applies
  4. Select all VAT/GST categories themselves
  5. Run the report
This will provide you a list of all transactions per category with their net value and the VAT/GST.

For my tax report I only need the following items:

  1. total of VAT/GST paid
  2. Total of net income received
  3. Total of VAT/GST received
so I did not select the expense categories for goods and services in my report.

crun wrote:Annoyingly they all show "Split Transaction" as the category now. WTF?

Yes, but you can hover your mouse over that text and gain a view of the details.

crun wrote:someone says to make sure "show in tax reports" is checked. I have yet to explore how they will work

This does not have any effect on the above mentioned method.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.1 64bit, KF5
Abonz411
Registered Member
Posts
3
Karma
0
crun wrote:...someone says to make sure "show in tax reports" is checked. I have yet to explore how they will work

Annoyingly they all show "Split Transaction" as the category now. WTF?


Yeah checking that out now as still using Kmoney.
Thanks.
Abonz411
Registered Member
Posts
3
Karma
0
ipwizard wrote:...Here's what I did:
  1. Setup the categories as you did. That is perfectly OK.
  2. Take a Transactions by category report as a base
  3. Select all income and expense categories for which VAT/GST applies
  4. Select all VAT/GST categories themselves
  5. Run the report
This will provide you a list of all transactions per category with their net value and the VAT/GST.

For my tax report I only need the following items:

  1. total of VAT/GST paid
  2. Total of net income received
  3. Total of VAT/GST received
so I did not select the expense categories for goods and services in my report.

crun wrote:Annoyingly they all show "Split Transaction" as the category now. WTF?

Yes, but you can hover your mouse over that text and gain a view of the details.

crun wrote:someone says to make sure "show in tax reports" is checked. I have yet to explore how they will work

This does not have any effect on the above mentioned method.


Thanks IPwizard as well.

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], Bing [Bot], freddylegen, Google [Bot], grahm, irvingarrietavazquez, Majestic-12 [Bot], nrykhe, paleo, rblackwell, Sogou [Bot]