AllBalancesLink Excel Add-In for Peachtr 1.0

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 dont 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.