Profit Loss Spreadsheet
An open general-store account page with dates, goods, and a month balance in columns

Profit Loss SpreadsheetThe bank match before profit

Steven Palmieri is a Tax CFO, the Entrepreneur's CFO.

The books stay here, a payday account is connected for you to run, and the return waits until those months already agree with the bank.

Start with the file

Name the columns you have

You will be talking to the Steven Palmieri practice.

The Tax CFO way with a spreadsheet

A spreadsheet tells you what the rows add up to. The Tax CFO tells you whether the rows are true, and then what to do about the month they describe. The estimate, owner pay, and the plan come after a match. One count says what happened. The next decision says what happens next.

Six places a file goes quiet

The cash-register photograph is by Geraldshields11, CC BY-SA 4.0, on Wikimedia Commons. We cropped it.

Six ways a file looks finished

Open a row. Each one names a mix-up we see in a file, and the column that would have caught it.

  1. 1Only three headings

    We add the columns the statement needs

    Income, expenses, and profit can sketch a month. They cannot show which lines cleared, so the profit cell is still a guess.

  2. 2A deposit that is not sales

    We park it outside the rollup

    A customer payment for work you have not finished yet raises the bank balance. It is not profit until the work is done.

  3. 3Cash moved to you

    We keep a column for draws

    Money you move to a personal account changes cash. It is not a cost of the shop, and it does not belong in the profit cell.

  4. 4A loan in the deposits

    We keep a column for loan money

    Loan proceeds and loan principal change cash. Treating them as sales, or as an expense, makes the year look nothing like the return.

  5. 5No cleared column

    We add a yes or no before the rollup

    A line that has not cleared cannot help the statement match. The profit cell waits until the cleared lines equal the ending balance.

  6. 6A tab that will not match

    We leave that month out of the year

    Twelve tabs can share one file. A tab that fails the statement stays out of the sum. Adding it in hides the break.

Name the mix-up

The part people open next

The equality the statement asks for

Prior statement balance, plus the lines that cleared for that account, equals the current ending balance. When the equality fails, stop and find the line. Decorating the profit cell first is how a file looks done while the bank still disagrees.

That pause is the relief. A profit cell that looks finished is a comforting object. Asking it to survive a statement is the better ask. We would rather spend the hour on the line that broke the match than on a formula that hides it.

Draws, loans, and transfers

Owner draws, loan proceeds, loan principal, and transfers between the company's own accounts keep columns of their own. They change cash. They stay out of profit, which is income, cost, and expense only.

A loan deposit feels like a good week at the shop. The register was ordinary and the bank was suddenly full. If that deposit is coded as sales, the year smiles and the return later does not. The same thing happens when cash moved to you is coded as a cost. The shop did not spend it. You took it.

Twelve months, and the one that fails

Twelve months can share one file. Each month matches on its own. The year is the sum of months that already matched. A tab that fails stays out of that sum.

People feel this in January, when a year of tabs is about to become a return, and one month still has a gap. Leaving that month out is uncomfortable. Adding it in is worse, because the gap then hides inside a total nobody can point at.

The file you already have

The file you already have is the one to reconcile. A fresh blank does not explain the old rows. The scope here is that match, not a priced cleanup sold as a new workbook.

Paper is a picture until the file exists. A printed page can be looked at. It cannot match a statement, because a picture has no cleared column. We build the file from the statement. We do not teach a paper-reading class.

A receipt, a payday notice, a federal date

A receipt on the counter and a deposit on the statement are not the same event. The receipt says a sale happened. The deposit says cash arrived, and it might have arrived for a different reason. The cleared column is where those two stories meet.

A payday notice looks the same in every state. It names a provider, a deposit date, and a wage total. Opening that account is our part. Every wage run after that stays on your side of the counter. The wage total later has to agree with the file. If it does not, the return is guessing.

A federal estimate voucher gets written in April, again in June, again in September, and again in January, and any of those four is a guess while the spreadsheet's cleared column is still blank. A voucher taken from a file the statement will not support is how April becomes a surprise. A letter from the IRS about an underpayment is a miserable way to learn the profit cell was early. We would rather the months match before the voucher is due.

Tell us which month is open

You will be talking to the Steven Palmieri practice.