Owner statement similar to Appfolio in QBO, how?

jn_0101 · ‎September 30, 2024

I am currently working for a property management company, and my employer has requested that I create an owner's statement that includes detailed transaction information. This report should summarize the beginning balance, cash inflows and outflows, net owner funds, and the amount to be remitted or paid on a monthly basis. For reference, the beginning balance for January is nil, and the ending balance should be reflected in February.

My employer provided an example of an Owner's Statement generated in AppFolio, and I need to replicate this formatting in QuickBooks. If anyone has guidance or assistance in creating this monthly statement, I would greatly appreciate your help. Thank you!

ShyMae · ‎September 30, 2024

Hello, jn_0101. You can generate the Statement of Cash Flows report in QuickBooks. It gives you a complete summary of your transactions, detailing the cash flow in and out of your business.

This report includes beginning or ending balances in a specific month with cash in, cash out, and net owner's funds.

I recommend exporting the information to Excel and manually calculating and adding a column for the total cash-out or cash-in amount.

Here's how you can pull up the report:

Hover to the Reports menu. Enter Statement of Cash Flows in the search bar.
Choose your preferred date period. Hit Run report.
You can click each amount to see the transactions associated with it.

Please see the attached sample for reference.

Besides, you can export the Balance Sheet report to Excel and remove unnecessary accounts you don't need. The option to do it within the program is unavailable.

For additional information you need to view, kindly refer to my colleague Iriz's suggestions.

Moreover, you have the option to memorize the reports you've customized. This way, you won't have to do the customization process again.

To learn more about what you can generate, check out this article: Reports included in your subscription.

You can always count on me for assistance, jn_0101. If you have other queries, please let me know below. Hope it all goes well!

View solution in original post

IrizA · ‎September 30, 2024

I'll be happy to assist you in creating or pulling up your monthly statement in QuickBooks Online (QBO) so you can make an owner's statement, jn_0101.

When viewing the detailed transaction information, including the beginning balance, net owner funds, inflows, and outflows, we can pull up the Balance Sheet Detail report and customize this according to the information you want.

Here's how:

Go to the Reports menu from your left navigational panel.
Enter the Balance Sheet Detail report from the Find report by name field.
Click the Customize button.
Select a date you want to include in your report by clicking the Report Period section.
You can also customize the number format you want to see in your report.
From the Rows/Column section, click the Change Columns and tick the columns according to your preference.
Within the Filter section, you can modify or specify what you want to include in your report.
Click Run Report.
You can press Save Customization, then name this custom report.
You can Add this to a group or select an option in the Share with dropdown, then click Save.

After viewing this report, you can email, print, or export it outside QBO.

Please let me know if you have additional questions regarding reports in QBO, jn_0101. We're still here to help you out.

jn_0101 · ‎September 30, 2024

Hi! Thanks for the response, I am looking for something like this(PFA). Also in balance sheet if i do not wish to show some accounts as they are meant for tracking only, can that be done?

jn_0101 · ‎September 30, 2024