Skip to Main Content
Sage 200 UKI Ideas Portal

Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.

ADD A NEW IDEA

Clear

Ideas

Showing 44

Improve Excel VAT Transactions Report

The current VAT Transactions report (Excel) records the VAT on Sales Invoices as a positive amount, rather than as a negative amount and Sales Credits as negatives instead of positives so that the cumulative total differs from the VAT return. Can ...
David Waller almost 2 years ago in Excel Reporting 4 Idea Accepted - Gauging Support

VAT Transactions report (by period)

Please add NLNominalAccounts.AccountNumber NLNominalAccounts.AccountCostCentre NLNominalAccounts.AccountDepartment columns on the VAT transactions report (by period). This will help to analyse the transactions and calculate the VAT partial exempti...
Nafees Anjum almost 2 years ago in VAT 1 Idea Accepted - Gauging Support

Option to automate the transfer of VAT from the sales and purchase tax control nominals to the VAT liability nominals post completing a VAT return

For there to be an option to automate the transfer of VAT from the sales and purchase tax control nominals to the VAT liability nominal post completing a VAT return rather than this having to be journaled manually each time.
Guest about 2 years ago in VAT 1 Idea Accepted - Gauging Support

View attached purchase/sales ledger invoices while in VAT Analysis

Being able to instantly cross-reference transactions with their supporting documents (invoices) helps ensure that VAT amounts are correctly recorded and claimed. This reduces the risk of errors and improves compliance.
Robyn Robyn 2 months ago in VAT 0 Idea Accepted - Gauging Support

Include 'Narrative' Column in VAT Breakdown when using the VAT analysis module and clicking on the purchases/expenditure values

We are a charity and use separate VAT codes for non business, residual VAT etc. I need to be able to check that the item has been given the correct tax code and the information i need is contained within the narrative column/section.
marie purcell almost 2 years ago in VAT 3 Idea Accepted - Gauging Support

Add narrative column to excel report Supplier Transactions

I would find the Supplier Transactions report, which can be found in the excel reports, much more useful if a column showing the narrative was included. When processing invoices we leave the default narrative, which includes the supplier code and ...
Guest over 2 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Bank Payment Refunds are treated as purchases on VAT return - should be negative income

We are an Academy and have had to process lots of parent refunds for cancelled school trips. We are also VAT registered and partially exempt. The refunds are processed as VATable payments with an outside the scope VAT code in order for them to be ...
Guest over 5 years ago in VAT 1 Idea Accepted - Gauging Support

Excel Reporting - Revenue and Cost report: flip sign on budgets

A client is using the Excel Revenue and Cost report to extract budgets and actuals from Sage 200 for reporting. The actual values are signed flipped, so that the revenue credits are displayed as positives and the cost debits as negatives. Budgets,...
Gregor Imrie over 4 years ago in Excel Reporting 0 Idea Accepted - Gauging Support

Add Excel Pivot on Invoicecredit and Invoice Credit Line

Useful to bolster existing trading reports e.g. if stock updated by despatch date then such trading information is unavailable.
Owen Orr 6 months ago in Excel Reporting 1 Further Information Required

Sage 200 web users able to drill down into budget line details

We have rolled out "My Budget Overview" access to our managers for keeping more up to date view on budget spend than monthly management accounts allow. However it would be useful if the figures in actual/committed POs/etc columns were able to be d...
Jo Clarkson over 6 years ago in Excel Reporting / Roles 0 Idea Accepted - Gauging Support