C
cindyj
I am using Excel 2003 - I receive all of our payables here and then approve
and code them with amounts to distribute to expense accounts to be sent to
our corporate office for payment. I need to create a workbook that allows me
to track payables by multiple criteria.
Example Payable
Joe's Hardward Invoice Date 07/01/09 Invoice #12345 Invoice Total=$100
Distribution of Expenses;
Acct 2450(Hardware)=$50
Acct 2475(Auto Expense)=$50
right now I am doing double entry - one workbook that tracks individual
batches of payables sent - lists vendor, date, invoice # & invoice total. In
this one, Joe's hardware would be on one line, easy entry.
In the other workbook I enter each payable but broken by account - On this
one, Joe's Hardware would be on two lines (one for each internal account) but
with no way to reference the actual invoice total - this leaves room for
error if one account is left off or if distribution of the invoice total into
accounts is incorrect. This workbook then flows the data from the
"transactions" sheet to my summary sheets that provide totals by vendor and
by expense account.
How can I mesh these two entries to create a single entry method that tracks
batch totals as well as breaks down expense distribution???
and code them with amounts to distribute to expense accounts to be sent to
our corporate office for payment. I need to create a workbook that allows me
to track payables by multiple criteria.
Example Payable
Joe's Hardward Invoice Date 07/01/09 Invoice #12345 Invoice Total=$100
Distribution of Expenses;
Acct 2450(Hardware)=$50
Acct 2475(Auto Expense)=$50
right now I am doing double entry - one workbook that tracks individual
batches of payables sent - lists vendor, date, invoice # & invoice total. In
this one, Joe's hardware would be on one line, easy entry.
In the other workbook I enter each payable but broken by account - On this
one, Joe's Hardware would be on two lines (one for each internal account) but
with no way to reference the actual invoice total - this leaves room for
error if one account is left off or if distribution of the invoice total into
accounts is incorrect. This workbook then flows the data from the
"transactions" sheet to my summary sheets that provide totals by vendor and
by expense account.
How can I mesh these two entries to create a single entry method that tracks
batch totals as well as breaks down expense distribution???