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.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.