ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Setup Accounts Receivable functions in Excel til we get new syst? (https://www.excelbanter.com/excel-worksheet-functions/31224-setup-accounts-receivable-functions-excel-til-we-get-new-syst.html)

desertmoon

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!


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com