Onion Lite for Sage 50 UK - FREE data extraction tool giving up to 24 months of TBs at a time backed by transaction level detail

Onion Lite is the essential free toolkit that belongs in every Sage 50 UK user’s arsenal - the perfect introduction to the powerhouse capabilities of the premium Onion and Onion Extra tools.

While standard Excel sheets max out at 1,048,576 rows, Onion Lite shatters this barrier. By writing your transaction-level data directly into a highly compressed and invisible PivotTable cache, it handles massive datasets without ever hitting grid limits or bloating your file sizes.

What you get with Onion Lite:

• 24-Month Visualisations: Extract any two years of transactional data for any Sage 50 client, instantly structured into 24 monthly trial balances that match your chosen Sage chart of accounts.
• Instant Drill-Downs: View automated financial summaries with the power to drill straight through to the underlying, transaction-level details.
• Frictionless File Sharing: Because the data sits safely inside the PivotCache, you can send macro-free workbooks to non-Sage users. They can slice, dice, and query the data interactively without needing an active Sage database connection.

It truly is a tool you have to see to believe. Download it for free today at onionrs.co.uk, and rest easy knowing our free helpdesk support is on hand to help you customise your displays.

Enjoy!

Sage Line 50 / Instant month end reporting using Onion Reporting Software's Onion product

One of the issues users frequently ask about is how they can monitor any “back postings” made in Sage since their previous monthly reporting cycle.  For example, a business may have a reporting cycle that produces reports for a month end five working days after that month end.  Using Onion as the reporting option will produce month by month spend figures for each month in the year to date as at working day five of the new month.  If, on working day six of the new month, a late posting is made to the previous month, how is the user of the Onion reporting pack next month to be made aware of the prior month posting?

The [Onion info] sheet of each Onion workbook records the “Last transaction number” at the time of workbook creation.  This identifies the cut-off point for the reporting pack.  The next time an Onion workbook is created, the user can ask to have postings made after that cut-off point identified in the new Onion workbook. The user ticks a check box, provides the last transaction number from the previous reporting pack, and runs the report. On completion the user can set the NEW_POST filter on the [TB Pivot (YTD)] sheet to Y to see what months have been posted to since the last report. Double clicks on the month totals will show the transaction detail of what was posted.

Sage Departmental reporting in Excel

See the YouTube video showing Onion Reporting Software's free complementary template and how it interacts with the Onion workbook produced from Sage Instant or Sage Line 50 accounting data by their Onion software.