Controlador_ABL.jpg, 45 kB
Welcome to AllBalancesLink!

AllBalancesLink is an Excel* add-in for Peachtree*.

AllBalancesLink uses a new add-in architecture introduced from MS Office 2000. This new technology allows the use of interfaces (forms and dialog boxes), therefore enabling much easier user-friendly applications than for instance, DDE implementations.

As we are all aware, the production of finance reports, requires the extensive use of Account balances, Job balances, budget standing, consolidations and comparisons of certain periods within others, and generally the process to obtain this kind of information is a hassle because not all data is accessible and in the format we require.

It would be great if there were a tool to make these tasks easier.

AllBalancesLink is this tool.

AllBalancesLink can transfer from Peachtree to Excel, Account Balances, Jobs or a combination of Accounts, Jobs, Date Ranges, Customers ID, Job Type, PO Number, Phase ID and Cost Codes among others, correlating these data with other manually inserted values by the user in the order that is most convenient, enabling you to produce reports for whatever purpose needed.

The data is taken directly from one or more Peachtree databases, at your discretion, therefore:

  • You don't have to retype into the spreadsheet, values listed in reports, avoiding typing errors and eliminating needless labor;
  • The balances are retrieved from a trustworthy database, where the data has been examined and analyzed, differently from balances manually typed into a spreadsheet, which are inconsistent and not trustworthy.
  • You may transfer the balance to whatever cell you wish, non-sequentially, according to the spreadsheet design.

  • Has the database changed after a balance input? No big deal, the update is simple and practical, and the spreadsheet cell containing the retrieved balance will reflect the update.

    The possibilities derived from the use of AllBalancesLink to create financial reports are extensive and wide reaching; your imagination is the limit.

  • Have you thought up a report model and this report doesn't exist on Peachtree?
  • Do you need to blend into one report the financial information from more than one Peachtree Company?
  • Do you need to reflect several years of information in one report from one or more Peachtree companies?
  • Do you need to produce a budget for one or more companies, and control the discrepancies between ACTUAL X BUDGETED?
  • Do you need to make previsions/projections based on updated balances from Accounts/JOBs?
  • Do you need to fill in governmental/official forms?
  • Do you need to fill in forms for customers, suppliers and/or investors?

  • If you answered YES to any of the questions above, AllBalancesLink will be very useful to you.

    * Peachtree is registered trademark of Best Software SB, Inc.
    * Excel is registered trademark of Microsoft Corporation.