Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
desertmoon
 
Posts: n/a
Default Setup Accounts Receivable functions in Excel til we get new syst?

I need to setup basic AR functions in Excel until our new computer system is
in place. I am currently using it as a work sheet to sort through & clean up
AR stuff. I have started a rolling forward net balance after all invoicing,
paymnets, adjustments are applied. I don't know if this is the most simple
way to do it for now. Plus, it would be nice to have individual accounts
setup to apply the transaction against, but I am concerned about the time
involved, space on server, etc. I have been using my Excel worksheets to do
Mail merge with Word to print invoices too!
Reply
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
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel Statistical Functions and Routines David A. Heiser Excel Worksheet Functions 0 June 3rd 05 05:27 PM
Using Excel for Accounts Payable - Comprehensive MidNiteRaver Excel Worksheet Functions 2 March 7th 05 08:27 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM
How do I setup a spin button in excel Andy K Excel Discussion (Misc queries) 1 November 26th 04 09:08 PM


All times are GMT +1. The time now is 06: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"