Our small accounts payable department needs a database to keep tract of what has been paid, the accounting codes used, and to help streamline the accounts payable process.
Currently the system is:
1) the accounting codes that are appropriate for each invoice/bill are written on the physical copy by hand. If there are multiple invoices from the same vendor (Comcast for example), then a coversheet is printed and contains all the necessary coding for the invoices that follow it (An example coversheet is attached for reference).
2) after the invoice/bill is coded and ready to be paid, it is logged on a running spreadsheet so that there is a record of the bill after it is sent to the accounting department to be paid.
What we need:
A database that simultaneously catalogues the coded invoices/bills, and generates a coversheet similar to the attached example. There should, ideally, be a cover sheet generated for each vendor containing information for all the invoices/bills to be paid since the last coversheet was generated.
design the database to suit the needs of our AP dept
build the database to suit the needs of our AP dept
database design, database building, basic database application knowledge,