Child Expenses | REPORTS+ VERSION | Works for any year. | Automatically generates all reports.
Expense tracking- easily log all your expenses related to your child. Yes! This can also include child support. Not only are you logging and documenting your coparent's efforts (or lack thereof), you are also tracking how you support your child financially.
If you have any questions, please ask prior to purchase. Sup@SplitAF.com is the quickest way to get a hold of me. Please note, this is not an excel file, it is through GOOGLE SHEETS.
Reports+ Version Benefits: Works for any year. Can be reused each year. Automatically creates "invoice" style monthly reports for each parent. Easy to print. Give your lawyer access in a few clicks. Breaks down amount paid/balance by category for each parent and compares the two. Automatically generates all tables, charts, graphs, and percentages. Ability to filter & sort data. Easy to run reports. For example, if you want to pull all medical expenses or only want to pull the data where your coparent has not paid in full, you can easily do so in a few clicks!
EXPENSE SHEET: PRO EDITION
WHAT YOU LOG:
Date, Name of Company, Description, Total Amount of Payment, Percent Parent B Pays, the category, check off whether or not each parent paid specific expense, add partial payment amount if needed. You can also add in and customize your own concerns, notes, or if you need to link it to a piece of evidence.
WHAT THE SHEET WILL AUTOMATICALLY DO FOR YOU:
Automatically calculate how much each of you owe for each expense, calculate the balance remaining for each parent
Create a year tab complete with: total paid/balance for each parent with pie graph, total paid/balance sorted by category with percentages for each, comparison bar graphs to show comparison of how much each parent paid per category, & a comparison bar graph for how much each parent owes per category.
Create a month tab for each parent with: total paid/percent paid for month, total paid/percent owed for month, total owed/percent owed for the month, amount paid YTD/percent paid YTD, monthly amounts per category (paid, owed, percent for each), generate a report including date, title, category, total amount for that parent, balance remaining. It will also automatically highlight items that are owed red for easy reporting. At the bottom of the report, it will automatically generate the pie graphs to show totals of owed/balance for month and year to date.
** To change the month, type the name of the month in the Month cell and it'll automatically pull over all the data for you **