LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
MidNiteRaver
 
Posts: n/a
Default Using Excel for Accounts Payable - Comprehensive

I am looking at putting together an accounts payable workbook. I was
wondering though if they was one someone had done already, in which case I
wouldn't reinvent the wheel, but simply download it.

I need the workbook to have a main page which would indicate all the
suppliers, the totals owed, days out standing etc.

The individual suppliers sheets would have each invoice entered, along with
the following data, invoice date, invoice item total, invoice additional
charges total (shipping , packing etc), our purchase order for that invoice,
the PO date, currency. The sheet must allow for multiple payments on the same
invoice each showing days from date of invoice due.

Yes essentially I should be using a database program but they tend to be too
messy, and get worse when things go wrong.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 12:02 AM
html to excel nellie Excel Discussion (Misc queries) 4 February 8th 05 10:37 PM
Merge from Excel to Excel dalstar Excel Discussion (Misc queries) 3 January 30th 05 02:37 PM
Shortcut file fails to open JimH Excel Discussion (Misc queries) 3 January 15th 05 10:13 PM
pivotcell object to excel 2000 Kellyc Excel Discussion (Misc queries) 0 December 1st 04 03:45 PM


All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"