i'm trying to get a report for the VAT that shows the actual nominal codes items have been posted to. the current VAT Detail report shows the type of transaction it is but i'm wanting to see a report to know what expense codes items have actually been posted to so we can see where any changes have been made.
I am aware that the exception report will show the item if the nominal code is changed after filing but that still doesn't tell me what the transaction has been moved to/from. ideally if this is something that can be accessed by the "Reports" tab as this is for an company where we are a reports only user.
It is not possible to run a VAT report that includes the nominals/accounts that the transactions are posting to. When you run the exception report you could then select the particular transaction and select the more option and view audit log, this will inform you nominals have been changed within the transaction.
You could run a transaction by account detail report for the date range of the VAT period you require ensuring you customise it to include the tax amount, net amount and VAT code.
i have found two reports which "almost" work to show the information. Transaction list by account shows the tax amount and nominal code, but if the payment was for an invoice that had more than one nominal (i. e. purchase and postage on one invoice) then the nominal code only shows as "split".
the Transaction list with Splits shows me all the nominal accounts items are posted to but for some reason the tax amount isn't a column i can show in this report, so if i have a split between 20% and 0% the first report shows them as "split", even if both to the same nominal code, and the second report doesn't show which part is 0% and which is 20%
also running the exceptions report from the reports page only allows me to see the current quarter not look back at previous returns that have been filed so i can't use it to see what the exceptions were on previous returns without being in the taxes section, which i can't do as a report only user.
Running the Transaction Detail by Account will really post the Split amount since the transaction will repeatedly be posted to each of it's account affected.
In this case, you can pull up the Purchases by Supplier Detail then add a column for the account, VAT code, and tax amount. This way, all supplier's transaction includes the item and accounts affected will show up.
To do that:
Click on Report at the left pane.
On the search box, key in PurchasesbySupplierDetail.
Make sure to choose the correct date range.
Tap on the Customise button at the top.
Hit on the Rows/Columns field.
Add the Tax Amount, VATCode, and Account in the column by putting a checkmark on the box.
Then run the report.
Please refer to the screenshots below, so you'll have a visual reference of the steps:
You can do the same thing for your customers transactions, just run the Sales by Customer Detail and add the given column above.
Reach back out to me if there's anything else that you need. Have a wonderful day!
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
We have to collect some data when you use this website so it works and is secure. We'd also like your consent to collect data to study how people use our site. Doing so helps us improve our services and allows us to tailor the marketing you see on our site. Select 'Accept all' to agree or 'Manage consents' to choose which cookies we use. You can change your mind at any time by clicking the 'Manage Cookies' link.
Choose your cookie preferences
Some cookies are needed to make our website work and can't be turned off. But we need your consent to use others that are not essential. You can make your choices below and update them at any time using the 'Manage Cookies' link. To find out more, visit our Cookies Policy.
These cookies are necessary for the site to function. They also help us keep your data safe.
These cookies allow us to enhance your experience and remember your preferences, region or country, language, and accessibility options.
These cookies tell us how customers use our website. We study and organize this data to help us optimise our content and provide you with personalised experiences.
These cookies help us provide you with relevant communications and ads in our products and on other sites.