Billing: Inv Rpt

SwimOffice Admin - Super User

The Invoice Report is used to see what payments correlate to what invoices based on the accrual method of accounting. To generate this report,

  1. In the side menu click Billing Admin > Invoices & Payments > Inv Rpt tab.
  2. Select the Month/Year for which you wish to see the data.
  3. If you want to see fees for members in a certain Location, select one from the Location dropdown, otherwise leave it as --ALL--. Keep in mind that this goes by what location members are in currently, NOT what location they were in for the time period you are looking up. If a family has members in more than one location, fees for the entire account will be included.
  4. Click the Generate Invoice Report button.
  5. Once it's generated you can click Export to EXCEL or, for even greater detail, Export Posting Data to EXCEL.

This report if generated for October, for example, will show the following:

  • All payments made in the month of October (this report is dynamic and will continue to add payments until the last day of October).
  • All non-recurring charges generated in the month of September.
  • All recurring charges generated October 1st.

This report will help the Treasurer reconcile dollars to total invoices but will NOT show what dollars paid apply to which CoA. Remember, the TU billing system is accrual based and not cash based.
Inv Rpt screen

What the column headers mean:

  • Account Name: What it says.
  • Prior Invoice Balance: This will be balance left over from the previous month (in our scenario it will be Sept).
  • Total Invoice Amount: The total of all of the CoA invoices generated for the month (in our scenario it will be Oct. invoices).
  • CoA column headers: Breakdown of all invoice charges, including non-recurring and recurring. The total of all the CoA columns will = the Total Invoice Amount column.
  • Payments Items: All payments made during the month (in our scenario it will be all Oct. payments), with amount, date and payment method. Hover over a payment to see the check # and who posted it.
  • Refund Items: All monies refunded to the account (in our scenario it will be refunds in Oct), with amount, date and refund payment method. Hover over a refund to see who posted it.

See Also
Payment Sum report
View what goes into a QuickBooks IIF file from SwimOffice
What is Accrual Based Accounting vs Cash Based Accounting?

Billing Management

  1. Billing System VIDEO Tutorials
  2. What is Accrual Based Accounting vs Cash Based Accounting?
  3. Warning in the invoice and payments area
  4. Bringing balance forwards or previous balances over to start the billing system
  5. Make, record, enter or add a payment
  6. Billing: Create or add a New Credit invoice
  7. Billing: Additional Per Account Charges
  8. Billing: Additional Per Member Charges
  9. Add or create a new invoice item
  10. Deleting an uninvoiced item
  11. Refund a Credit Balance when refunding by check
  12. Enter a bounced NSF check
  13. Credit Memo versus Credit Refund
  14. Applying the different filters in Billing Admin > Invoices & Payments
  15. How can I see the Account Level recurring charges for all my accounts?
  16. Billing Simulation Report
  17. Billing: Aging Report
  18. How do I print a check register or bank deposit form?
  19. Generating an Un-Invoiced Report
  20. View past invoices / billing history report for accounts
  21. Deposit Report
  22. Billing: Invoices & Payments Overview tab column headers
  23. Billing: Inc & Pay Sum report
  24. Billing: Inc Trans Rpt
  25. Billing: Inv Rpt
  26. Billing: Payment Sum report
  27. Billing: CoA Sum report
  28. Billing: ACH Status - failures and processed amounts
  29. Billing: Rec Inv Sum, credit cards processed
  30. Can I post a payment against a chart of accounts?
  31. Billing: Delete/hide/unhide chart of accounts (CoA)
  32. Billing: Merge chart of accounts (CoA)
  33. Email Billing Summary and Best Practice
  34. Does TeamUnify handle Escrow accounts?
  35. What credit cards are accepted by electronic processing?
  36. ACH and Credit Card Failure
  37. ACH is still pending
  38. Billing: ACH/Credit card FAQs
  39. What do these codes mean when I see the results of an ACH run?
  40. Credit card and ACH Auto Pay security
  41. Refunding Past/Historical Credit Card / CC charges
  42. Billing: Credit card expiration failure and report
  43. Refunding on demand or Credit Card /CC payments
  44. Billing: Delete an Account's credit card or ACH information
  45. Billing: On demand charges and payments for Admins
  46. If an account is NOT active and they have a CC or ACH against their account will they get charged?
  47. Billing: Void a CC transaction immediately (instead of using Refund option)
  48. Is there a "Processed ACH report" PDF like there is a credit card PDF report for auto payments completed via ACH?
  49. Billing: Set up auto pay for a family
  50. Are accounts notified when an on demand payment fails?
  51. Billing: Refund an ACH payment or credit card donation
  52. Can I use a debit card for credit card processing?
  53. Service Not Allowed error when using debit card in Canada
  54. Invalid Term ID error when using a credit card
  55. How do I change the bank account into which TeamUnify site deposits payments?
  56. How do I generate a meet fee breakdown PDF for a Meet?
  57. Billing: Export and bill from Team Manager events file
  58. Billing: View invoices/payments from account's perspective
  59. What bills on the first in the automated billing system
  60. How do I add notes on invoices?
  61. How do I delete my payments in the IIF import?
  62. QuickBooks CoA shows $0 or negative amount after IIF import and Account Type set to Bank
  63. Add or edit a billing group
  64. Billing: Email auto pay instructions - Notify families team accepts credit cards/ACH
  65. How do I print an invoice?
  66. How do I see what admin posted a payment or invoice in the billing system?
  67. Billing: Update team credit card/ACH account used to pay TeamUnify invoices
  68. How do you change who receives the TU invoices?
  69. How to Add Free Billing Account and Member
  70. View what goes into a QuickBooks IIF file from SwimOffice
  71. View contents of a QuickBooks IIF file
  72. Alternatives to view IIF files
  73. Manually enter SwimOffice transactions into QuickBooks
  74. How QuickBooks views refunds made in SwimOffice
  75. Quickbooks - Can I use Account numbers?
  76. Billing: Do SwimOffice QuickBooks Import IIF files work with QuickBooks Online?
  77. QuickBooks IIF File was imported but I don't see the receivables/invoice in my reports (Canadian date issue)
  78. Undeposited Funds - QuickBooks
  79. QuickBooks error line 6
  80. QuickBooks is not importing IIF file - multiple line errors (error line 6,9,15 etc) on first import
  81. Why are my transferred QB amounts negative?
  82. QuickBooks: Dealing with undeposited funds
  83. QuickBooks - Recording payments in QuickBooks undeposited funds to bank
  84. QuickBooks Error - you cannot have multiple AP or AR accounts (error varies)
  85. QuickBooks error line numbers. How do know what the line number is referring to?
  86. When does the QuickBooks IIF file generate?
  87. QuickBooks IIF import error - Can’t record a negative payment
  88. QuickBooks Error 21 or Tax Field Error given on IIF import
  89. When do my invoices generate and my billing run?
  90. Why are late fees being charged on suspended and canceled accounts?
  91. Why did my canceled accounts or suspended accounts receive an invoice email?
  92. Why do my canceled accounts appear under invoices & payments?
  93. Will the recurring charges post to suspended / canceled accounts?
  94. What email gets an emailed invoice or email billing summary?
  95. Viewing Past or Current Invoices Generated
  96. Reconcile the differences between TeamUnify and C & H Financial Services (formerly Process Pink)
  97. Double bucket billing - two bank accounts for deposits
  98. What will the Account see in their invoice for dollars donated?
  99. Billing: Avoid double billing accounts with Online Registration and recurring billing
  100. Billing: ACH - Invalid account number
  101. Relationship of Billing Groups, Roster Groups, Registration Groups, Locations
  102. Billing: Change/edit payment methods in Account
  103. Billing: Add a payment type as a family
  104. Billing: Non Admin update/change credit card
  105. Billing: Generate meet fees for unattached swimmers from results
  106. Billing: Invoice and charge meet fees
  107. Billing: View generated meet fees totals
  108. Billing: Cancel/undo/reverse meet fees
  109. Billing: Delete a meet fees batch
  110. Billing: Revert to generate meet fees (old ver)
  111. Billing: Invoice meet fees from an event (old ver)
  112. Billing: Invoice meet fees from meet results (old ver)
  113. Billing: Create a surcharge for meet fees (old ver)
  114. Billing: Cancel/undo/reverse meet fees (old ver)

Feedback and Knowledge Base