Kevlar Vest Girl wrote:

I'm looking for a specific function in this software. I want to be able to track expenses specific to a job number, and as I post to the job number, I want the information to migrate to a general data base that I can send to the accountant at the end of the month.

Any info?

It's been a while since I looked at the particulars.. but have you looked at the QuickBooks Pro software from Intuit?  It's a full bookkeeping and accounting package.  I'm pretty sure it has costing and billing sections.. and at the end of the year you can export all the data so that your accountant can deal with it.

Kevlar Vest Girl wrote:

One reason I gave up on programs like Quick Books is the redundancy issue when you make an entry mistake. Since I'm not actually doing the accounting, all I really am looking for is a customized spread sheet. If I knew how to make Excel do what I'm looking for, that would be sufficient.

It should be pretty easy to get excel to do what you want. I ran a retail store's books in Excel a while ago.. cross posted and referenced everything.. then dumped it out for the accountant.

Is something like the following what you're trying to track?

job number  101    102  103 ...

expense1    $10     $15  $45
expense2    $20     $10  $35
...
expense5    $70     $75   $10
...

total:      $1000   $900  $500

You can also tally all the "expense1" expenses over all jobs, etc.

This is assuming that each job has the same (or similar) expense categories.

After that some quick VB script (find a poor college student who will do it for beer if you can) should put it in a format that the accountant wants.

Kevlar Vest Girl wrote:

Peter Claver wrote:

Kevlar Vest Girl wrote:

One reason I gave up on programs like Quick Books is the redundancy issue when you make an entry mistake. Since I'm not actually doing the accounting, all I really am looking for is a customized spread sheet. If I knew how to make Excel do what I'm looking for, that would be sufficient.

It should be pretty easy to get excel to do what you want. I ran a retail store's books in Excel a while ago.. cross posted and referenced everything.. then dumped it out for the accountant.

Is something like the following what you're trying to track?

Code:

job number  101    102  103 ...

expense1    $10     $15  $45
expense2    $20     $10  $35
...
expense5    $70     $75   $10
...

total:      $1000   $900  $500

You can also tally all the "expense1" expenses over all jobs, etc.

This is assuming that each job has the same (or similar) expense categories.

After that some quick VB script (find a poor college student who will do it for beer if you can) should put it in a format that the accountant wants.

It just sparked an idea that I think will work. Thank you very much.

Excellent. My pleasure.

I'm late to the party as usual, but I'm a big fan of Billings for this kind of stuff.