About The Billing Report
The Billing report is intended to give you a fully detailed snapshot of your billing for a given period. This report should include everything necessary for you to understand revenue collected, outstanding invoices, discounts, refunds, failed payments, and more.
In general, this report is what your accounting team should use to balance books and understand your billing.
The report provides a .csv representation of what managers can see in the "Invoices" tab (see below).
Understanding The Report
The Billing report will break down all of the invoices that were sent, charged, or attempted to be charged for a given period. It also includes refunds, a breakdown of total revenue, and details on each invoice status.
In the report, you'll see several different tabs.
Here's a breakdown of each tab:
Billing Summary: A quick overall summary of totals of your billing for the given period
Payouts: A history of each singular deposit from Coworks into your bank account
Paid: A history of of each successfully paid invoice received for the period
Refunded: Any refunds that were initiated during this period
Unpaid: All outstanding unpaid invoices created during this period
Marked As Paid: Any invoice manually marked as paid for this period
Failed: Any failed transactions for this period (from card failures for example. These should generally also appear in the "unpaid" list unless rectified)
Breaking Down the Billing Report Columns
The Paid, Refunded, Unpaid, Marked As Paid, and Failed tabs all give you a list of invoices with those statuses. There are several data columns presented on each invoice row. Let's break down and understand some of the important ones:
Team: The team that this invoice was created for. If it was a non member, this field will say "Guest"
Campus: The campus of the associated team and which you should tie the revenue to.
Coworks Invoice URL: A clickable direct link to the invoice in the Coworks dashboard for further review or actioning.
Total Amount: Total amount invoiced to the customer
Amount Refunded: Only present if a refunded has been issued. Shows full amount of that refund (could be partial refund)
Transaction Fee: Transaction fee from the payment processor
Net Amount: Net amount that the space should anticipate to receive from this invoice
Team Admin: The admin of the team who will receive the billing communication for that team
Billing: The billing status of the invoice. One of either "Charge Automatically" meaning the invoice was auto-drafted, or "Send Invoice" meaning the invoice was emailed to the customer for manual payment.
Invoice Date: The date the invoice was issued
Discount: Only present if a discount has been added. Shows full amount of that discount
Plans: The line items or list of plans associated with the invoice
Payment Source: How this invoice was paid (bank account or card number)
Downloading the Billing Report
Go to the Reports tab.
Scroll down to the "Billing Report" and click "Download."
Choose whether you'd like to download a billing report for your entire community, or filter by a particular team.
Choose the time period you're interested in. You can view this month, last month, or set a custom range. The transactions and invoices will be limited to the ones that occurred in the given time period
Click "Request." A billing report will be sent to the email address associated with your Coworks account. The report may take up to 5 minutes to arrive in your inbox.
Happy Coworking!