https://docs.google.com/spreadsheets/d/1Ox9BqXPFIFdxp6r01sdzJwmUYlpg_MiNbFkpq2mw2bU/edit#gid=0
Start of month Retainer (A2:M17) - calculate client retainer based on the sum of Transactions and expenses from each clients ‘reports’ sheet (column I) (everything in and out of the clients retainer). Only Start of January needed
Sum everything in the reports sheet for each client before January 2019 and enter into clients Cells B3:B17
https://docs.google.com/spreadsheets/d/1Ox9BqXPFIFdxp6r01sdzJwmUYlpg_MiNbFkpq2mw2bU/edit#gid=0
Start of month Retainer (A2:M17) - calculate client retainer based on the sum of Transactions and expenses from each clients ‘reports’ sheet (column I) (everything in and out of the clients retainer). Only Start of January needed
Sum everything in the reports sheet for each client before January 2019 and enter into clients Cells B3:B17