Any Teck for Banking Reporting

vic120

Guru
5000 Post Club
8,931
OH
I need something I can get a detailed monthly report neat and easy to read

on where all my deposits from each source

Like a simple to read not just I got 20 carriers paying multible times a month

More organized what I have right now If I get 10 deposits from Aetna dn 5 deposits form UCH and on and on everything is just mixed
Unorganized and hard to manage

I need to break down by carrier and other sources
 
Comtrack.io . Evan mccuffrie who invested medizues for mapd disenrollments that was axed developed this. You can download all your commission statements monthly to this software and it tracks all commissions to the penny . it detects all commissions you should get that don't get. It's $69 a month . It's also for tracking commissions for loa agents and override commissions. I think they have a 2 week or 1 month free trial to try it out
 
Yea I dont know if that is what I am looking for, I get a lot of payments but I cannot tell you what I am getting monthly for this or that as everting is mixed

I am just looking to unsort without a lot of manual work

and not everything is direct from carrier I have some of my ACA is not direct from carrier and I have old renewal's from when I was with gohealth years ago

I have multible agent number for some carriers

I have a bunch of ACA MA med supp FE and dental carriers.

I would just like the banking to work like a crm I can ask let me see all the Aetna payments for med supp and then for MA and then for ACA and how times was I paid for that product and how much total
 
You can download most statements to quicken . I manually add all my deposits monthly . It takes 5 mins . Print out your monthly statement . Have a 11x14 piece of copy paper sideways and list your 20-30 company's at the top. Take 30 copies of the filled out heading to use in future months . Go down your statement and fill in you boxes and add them all up. Takes 5-10 mins a month max
 
All that you are asking can be done with an Excel spreadsheet . . . or Google Sheets.

Once it is set up you can review and analyze data in a matter of minutes.

I set aside 15 minutes today to import bank transactions for the month of June so I could make my EFTPS 941 payment by the 15th. I also tallied 2nd quarter payroll and have it ready to submit.

Or you can use a service like Tiller to track all your expenses.
 
Last edited:
I just saw this in the Tech Forum. I did not read it.

 
I just saw this in the Tech Forum. I did not read it.

I don't think Jerard's with us anymore. Seems like he had some health problems and he hasn't been seen for 8 years.
 
To create a bank register in Google Sheets, start by setting up the header row with columns like Date, Description, Debit, Credit, and Balance. Enter your starting balance and then use formulas to automatically calculate subsequent balances as you add transactions.
Here's a more detailed breakdown:
1. Open Google Sheets and Set Up the Header:
Go to Google Sheets and create a new spreadsheet.
In the first row, create your header. Common columns include:
Date (or Date of Transaction)
Description (or Transaction Description)
Debit (or Withdrawal/Spending)
Credit (or Deposit/Income)
Balance
2. Enter Initial Information:
In the second row, enter your starting balance in the "Balance" column.
You can also enter a starting description, like "Starting Balance".
If you have a starting date, enter it in the "Date" column.
3. Create the Balance Formula:
In the first cell below your starting balance (e.g., cell E3 if your starting balance is in E2), enter the following formula: =SUM(E2,C3,-D3).
This formula assumes your starting balance is in cell E2, your deposits (credits) are in column C, and your withdrawals (debits) are in column D.
Adjust the cell references if your layout is different.
Click and drag the small blue square at the bottom right of the cell down to apply this formula to the rest of your rows.
4. Add Transactions:
Enter the date, description, debit (if applicable), and credit (if applicable) for each transaction.
The balance column will automatically update based on your formula and the debit/credit amounts.
5. Customize and Format:
Format the "Date" column as "Date".
Format the "Debit" and "Credit" columns as "Currency".
You can add conditional formatting to highlight specific transactions or balances.
You can also add a chart to visualize your spending and income over time.
Tips for using the register:
Keep it updated: Regularly add new transactions to keep your balance accurate.
Double-check: Verify your calculations against your bank statements periodically.
Consider automation: BudgetSheet and other tools can help automate importing transactions from your bank.
This video demonstrates how to create a bank log ledger sheet in Google Sheets:

You can also make a check register in Docs . . . but it doesn't have the power of Sheets . . . everything would be a manual entry.

 
Back
Top