Plan your sales and expenses and let Reach Reporting automatically project Balance Sheet and Cash Flow positions, without the need for complicated formulas on your end.
Since AR/ AP/ Inventory calculations impact your cash balance, they should be an integral part of planning. First, plan your sales and expenses and let Reach reporting automatically calculate projected Balance sheet and Cash Flow positions, without the need for complicated formulas on your end.
Accounts Receivable (AR) on the Balance sheet represents money not collected from customers for invoiced sales. Similarly, Accounts Payable (AP) represents money you owe to vendors, for unpaid bills. Both AR and AP can be planned based on how quickly you expect to collect an invoice or pay a bill. Inventory calculations look at how efficiently your business utilizes purchased inventory.
For example, if you make a sale of 1,000 and have payment terms set to 60 days, the invoiced 1,000 will stay unpaid for 2 months and therefore in the AR balance for 2 months. After 2 months, when the invoice is paid for, the AR balance will go down by 1,000 and your cash inflow will go up by 1,000. Same for AP, the unpaid bills increase the AP balance but once they are paid for, they are shown as a cash outflow on the Cash Flow statement.
Configuring AR/ AP/ Inventory calculations within Reach Reporting:
Step 1. Go to the Settings gear icon located at the top.
Step 2. Select the AR/ AP/ Inventory calculation you wish to configure and click the “Enable calculations” checkbox. Map the desired Balance sheet account. You will have the option to select an AR Account directly from your Chart of Accounts. Then input % of cash sales, if you have any, and the average number of days for collecting invoices, paying bills, or turning inventory into sales or finished products. Next choose all Profit & Loss accounts from your Chart of Accounts that will contribute to AR/ AP/ Inventory calculations on the Balance Sheet and related Cash Flow projections.
Once you enable AR/ AP/ Inventory calculation the corresponding rows on the Balance Sheet are greyed out and locked.
Hover over a cell to display calculations for both Existing and New Balances. The Existing Balance is calculated using turnover ratios starting from the last referenced month. For budget that is the last month of the prior year and for forecast that is the last month with actuals. Turnover ratios measure how efficiently your business turns sales and expenses, used to generate sales, into cash by calculating the number of times the turnover happens over a given period. In the below example of 60 days payment terms, 50% of invoices get collected each month. Consequently the Existing AR balance will go down to zero in 2 months since all unpaid invoices should be paid within those 60 days. The New AR Balance is also calculated from the number of days set for collecting current month invoices, paying current month bills, or turning current month inventory into sales or finished products. In 60 days payment terms example the current month sales will be collected and transformed into cash in 2 months and in the meantime they will stay in the AR balance.
Go to the Reach Reporting app>
ARE YOU NOT CURRENTLY USING REACH REPORTING?
learn more at reachreporting.com
We are dedicated to helping you.
- Need Additional Help?
Your success is important to us.
Whether you're working as a CFO of a business or part of an accounting firm, Reach Reporting is here to improve your working knowledge of reporting and provide service tips and skills to ensure you're at the top of your game.
We make sure that you have access to staff members that are best suited to help you. We work together to resolve issues and create memorable moments that empower you to enhance your reporting skills.
We are here to listen to you. We understand that using new technology can be frustrating, so we can answer questions or jump on a quick zoom call. Our entire staff has an in-depth knowledge of Reach Reporting and can quickly direct you to best practices to improve your reporting.
We are here focused on providing solutions that save you time and increase your value. We continue to improve each day and look forward to visiting with you. Your communication with us is vital and appreciated.
Please feel free to chat with us by clicking the help chat bubble in the lower right-hand corner of this page.
Reach out to your Reach Reporting Rep and schedule a zoom meeting by clicking the meeting link in their email signature.
Or schedule to join our onboarding webinars
Reach Reporting is dedicated to helping provide a knowledge base that is easy to understand and informative. If you still have questions that have not been answered, please let us know by emailing support@reachreporting.com, chatting with our support team, or calling us at (877) 467-7637. We are here to ensure that you have a positive experience with Reach Reporting, as we want to continue to be the reporting solution you trust.
Need more access to Reach Reporting Resources?
Reach Reporting has a wealth of knowledge and a robust online community to support you as you create reports that provide powerful insight. Please look into the following resources.
Reach Reporting Blog: We add blogs to our site every month to give you great information in a fun and friendly manner.
Case Studies: We interview one company per month to help our clients highlight how they are using Reach Reporting and how it is improving their services and firm offerings. These case studies are invaluable to our community.
Knowledge Center: From simple to complicated, we provide step-by-step guidance to utilize every aspect of Reach Reporting in our robust knowledge center.
Video Tutorials: We know watching is sometimes easier than reading, which is why all of our tutorials are video-based in the video tutorial section of Reach Reporting and Youtube.
Social Networks: Join us on FaceBook, LinkedIn, Youtube, and Twitter.
Competitor Comparisons: We have looked at all the reporting solutions on the market. We provide you with an in-depth look at Reach Reporting compared to some of the strongest competitors out there on our competitor comparison page.
Monthly Newsletter: Go to the footer of reachreporting.com and sign up to receive the Reach Reporting newsletters delivered directly to your inbox. Our newsletters cover tips and tricks, current events in accounting, strategies to improve your advisory services, and much more.
We look forward to helping you build insightful reports,
The Reach Reporting Team.