On Nov 22, 6:09*am, GS wrote:
on 11/21/2011, Gord Dibben supposed :









Garry

The Template Wizard writes user-defined details from each transaction
out to a database in a summary workbook.

Not just for Invoices.........could be work orders or expense accounts
etc.

Gord

On Mon, 21 Nov 2011 19:59:08 -0500, GS wrote:

I'd be interested in studying the wizard addin if it writes to a
summary sheet. Otherwise, I intend to use ADODB if the bookkeeping file
is not open; write the sheet directly if the file is open.

Gord,
Thanks! I already know pretty much the what/how of what I want to do.
My bookkeeping part of the app is a multi-sheet project that handle
income, expenses, customers, vendors, P&L, chart of accounts, taxes,
personal tax forms, and any number of bank ledger sheets depending on
how many bank accounts you want to keep transactions for. Thus, I doubt
the wizard will work directly with my app but I still want to see its
what/how. Fact is, anyone generating enough invoices that mandates
automatic entry into some tracking component should, IMO, be using
commercial accounting software. As you probably know, these are
database driven. My app is entirely XL, each year being a new fiscal
period that new working files are created the first time the app opens
in a new calendar year. This precludes the bookkeeping file be
perpetual so that the customer/vendor data and COA remains current.
Clearing the income/expense sheet input areas is all that's required to
start a new period. Bank ledger sheets are replaced with new ones that
have the closing balances carried forward.

This is probably too complex to bother trying to make one's own
accounting app, but it's certainly much easier to use and is tailored
to input directly into our tax return e-forms (I'm in Canada). I
originally started with invoicing only, using one of the templates that
ships with XL. It just evolved into a bookkeeping project due to user
demand, which also led to redesigning the invoice template to be with
or without product/service pricing features for automatic filling in
fields. Very flexible, but as I said, it's probably overly complex for
someone to make since reasonably robust accounting software can be had
fairly cheap nowadays!<g

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Thanx for your reply Gord!

-Before we get too enthusiastic.........what version of Excel is your
friend running?

2007

- Do you know which Template she is using for her invoices?

No. The actual template used is not known.