Month: October 2018

In the previous installments (Part I and Part II), we discussed setting up the Vendor, creating the Purchase Order, making payment and discussed the impact to warehousing. For the final installment, we’ll walk through the final step for Prepayment processing. Once the inventory has been received, the final step to clear the prepayment out of […]

So far in Essential Excel Skills Every Controller Should Know, we’ve covered sharing a workbook with your team and using special features like Conditional Formatting and Sparklines to provide more depth to our reports. Now, let’s focus on some analytical functions. Microsoft has included What-If Analysis tools - Scenario Manager, Goal Seek, and Data Table. […]

Last time we discussed how to setup the Vendor for Prepayments. If you missed it, check it out Part I – Accounts Payable. Now let’s move on to processing a Purchase Order and the payment to the Vendor. The Prepayment % set on the Vendor card will default into the Prepayment tab on the Purchase Order. If the […]

In part 2 of Essential Excel Skills Every Controller Should Know, I discussed the use of Conditional Formatting and how it can be used to create more dynamic reporting. If you missed it, take a look. As we continue our effort to spruce up our financials reports, let’s look at Sparklines and the Quick Analysis […]

Now that we’ve covered Payment Terms and Payment Methods, let’s discuss the Prepayment functionality. In many businesses, especially ones where large capital outlays are required to purchase inventory, Vendors may request payment at the time of order placement just to begin processing the order. In those cases, we need to be able to process payment […]