Accountants use Excel all the time. Complete any requests for proposals (RFP) for any accounts receivable related vendors (e.g.Collection agencies). See Instructions on page 4 for information about completing this form. For additional space, use Continuation of Property Declaration. We're going to walk you through how to calculate accounts receivable in this guide. We'll demystify a myriad of different formulas and ratios you need to know. That all customer accounts are kept up-to-date. Conduct account reconciliation and manage month-end close procedures. Requirements. • Minimum of 3 years of experience in a bookkeeping role