Posted on 1 Comment

New Macros in Excel Course to handle prepayments

Breaking News & Updates

@danwarne Hi @danwarne If you're using Xero you'd have access to Hubdoc - But we believe Dext (ex ReceiptBank) is very good. Divipay uses Slyp so you get smart receipts in your software!…

About a month ago from Steve Slisar's Twitter via Twitter Web App

Excel Macros in advanced Microsoft online Excel Training courseWe are please to announce that our most advanced Microsoft Excel course (course 309) now includes a training exercise on Macros!

You may recall we asked the question as to whether it is better to give a discount and accept prepayments or to charge your normal price and chase invoices and statements? Well, we got our Microsoft Excel expert to create a simple table that enables us to keep track of prepayments as well as incremental reductions from this prepayment.

This file is a great tool to keep track of how much credit a customer has if you decide to invoice them in advance. There is a way of accepting prepayments in MYOB and our MYOB expert and resident BAS Agent is currently putting a guide together on how to handle prepayments using MYOB. Using Excel  can be a handy replacement for using MYOB in this one aspect of your business.

Best of all, Karen created a short guide that we have added to the 309 course training manual which explains how to replicate what she created. Both the Workbook and the demonstration file that Karen created are now at the learning site.

-- Did you like what you read? Want to receive these posts via email when they are published? Subscribe below.

Enter your email address:

Content Marketing by 123ezy

1 thought on “New Macros in Excel Course to handle prepayments

Comments are closed.