Tutorial: MS Query and Sage #2 - import balances into Excel. By David Carter
Following his first tutorial on how to set up MS Query and the Sage ODBC drivers, David Carter's second tutorial shows you how to extract monthly nominal account balances from Sage and import them into Excel.
We’ll start with a simple exercise to help you find your way round MS Query.
Sage offers numerous Trial Balance and P&L reports. But you can only print a TB or P&L for a single period. Often managers like to see the figures for several months side by side, which gives an idea of trends.