Use an Income and Expense Report Template

Choose either format:

• Copy the Google Sheets template
• Download the Excel file

Create 3 copies:

1. Baseline: Keep the supplied September example unchanged.
2. Verification: Use this copy for the independent checks in this guide.
3. Working report: Replace the sample data or add the staging workflow.

Before each independent check, reset the Verification copy from the unchanged Baseline.

The Income & Expense Report sheet contains these areas:

Don’t edit calculated cells in E4:E15, I5:J13, or H14:J14.

Set the period and plans on the left, then use the central and category summaries to review cash activity, pending amounts, reconciliation exceptions, and spending against plan.

In the Working report, replace the sample controls in B4:B9.

The supplied September example uses:

Enter dates as eight-digit YYYYMMDD numbers. The opening cash in B7 should equal the combined opening balances of the cash accounts represented in the transaction log.

Check that:

• B4 isn’t later than B5.
• B6 falls within the reporting period.
• B7:B9 contain numbers.
• Income and expense plans are zero or greater.
• A zero plan is intentional rather than missing data.
• Every value in B4:B6 represents a real date.

An eight-digit number can still be invalid. For example, 20260931 has the expected length, but September has no 31st day.

In the recorded examples, the as-of date is the month-end date, so B6 equals B5. Interim-date behavior hasn’t been established. Before relying on an interim report, compare it with known transactions at the period start, review date, and period end.

Enter expense categories in G5:G13 and their planned amounts in H5:H13.

The September example uses:

Confirm that H14 shows $9,500, then set B9 to the same amount.

Each category label must contain a value and be unique when capitalization is ignored. Don’t include both Travel and TRAVEL. Case-insensitive criteria could assign one expense to multiple summary rows, which may cause category actuals in I14 to differ from cleared expenses in E5.

Categories in the transaction log must match G5:G13. A misspelling or a hidden, leading, or trailing space can cause an expense to be omitted from its category result.

Don’t use *, ?, or ~ in category names. Their literal treatment hasn’t been verified in the report formulas, so the staging workflow rejects them.

For manual entry, add dropdown validation:

In Google Sheets, choose Data > Data validation > Add rule > Dropdown and reject invalid entries. In Excel, choose Data > Data Validation > Allow: List.

Dropdowns reduce manual-entry errors, but you still need to audit pasted or imported records. The staging workflow applies case-sensitive checks, so values such as income, cleared, or yes receive REVIEW.

Keep the synthetic records unchanged in the Baseline copy. Recorded Google Sheets execution with the September controls produced:

The control arithmetic is:

Net operating cash:
$8,050 - $5,615 = $2,435

Closing cash:
$8,500 + $8,050 - $5,615 + $1,000 - $1,000 = $10,935

Income versus plan:
$8,050 - $14,000 = -$5,950

Expense plan remaining:
$9,500 - $5,615 = $3,885

The category totals in H14:J14 should be:

Planned expenses: $9,500
Cleared expenses: $5,615
Remaining:        $3,885

A positive remaining value represents unused expense plan. A negative value means cleared spending is above plan.

If you’re using the Excel download, recalculate the workbook and confirm these values before replacing the sample data.

If your report fits within the supplied range, clear only A18:J29 in the Working report. Keep row 17 and the blank entry rows A30:J46.

Complete one row for each cleared movement or expected pending movement:

Keep one auditable row for each cash movement. The exact Type, Status, Category, and Reconciled values determine the report results.

Use Cleared only after the movement occurs in the relevant account. Pending amounts appear in E12 or E13 without changing cleared income, cleared expenses, or closing cash.

Record an internal transfer as 2 equal rows:

1. Transfer Out from the source account.
2. Transfer In to the destination account.

Transfers affect E7:E9, but they don’t affect operating income, operating expenses, or expense-category results. The workbook doesn’t confirm that every transfer has a matching second row.

For a correction or refund, add a new row with the original Type and Category. Enter a negative amount and explain it in the Note column. Don’t overwrite an already reconciled record. Zero-value rows have no financial effect, so correct or remove them.

Use a staging sheet when an import contains mixed date formats, blanks, whitespace, duplicate IDs, malformed amounts, or uncontrolled labels. This Google Sheets procedure reserves exactly 10,000 raw rows and doesn’t change the Baseline copy.

Set the required spreadsheet locale

These formulas use commas between arguments. They also assume a period as the decimal separator and commas for thousands, as in 1,234.56.

In the duplicate Working report:

1. Choose File > Settings.
2. Set Locale to United States.
3. Select Save settings and allow the spreadsheet to reload.
4. Confirm that entering 1234.56 produces a numeric value.

Changing the locale can affect how existing dates and numbers are displayed, so make this change only in the duplicate workbook. If your organization requires another locale, adapt and retest the formula syntax and number-conversion rules.

Create a sheet named Import_Staging with this schema:

Paste the CSV headings in row 1 and up to 10,000 data rows in 2:10001.

Preserve raw dates as text

Before importing data, select A2:A10001 and choose Format > Number > Plain text. If you use the Google Sheets file-import dialog, disable Convert text to numbers, dates, and formulas.

Do this before the data enters the sheet. If Google Sheets has already converted 01/09/2026 to a native date, you can’t recover the original DMY-versus-MDY intent from the resulting value. Reload that field from the source as text.

Set a dropdown in K2:K10001 containing exactly YMD, MDY, DMY, and SERIAL, with invalid entries rejected:

• YMD for 20260901, 2026-09-01, or 2026/09/01
• MDY for dates such as 09/01/2026
• DMY for dates such as 01/09/2026
• SERIAL only for a numeric spreadsheet date that you confirmed against the source

Every text date needs the applicable YMD, MDY, or DMY value. If the order is blank, misspelled, or capitalized differently, the normalized date becomes INVALID.

Numeric values from 1 through 99,999 are eligible to be interpreted as spreadsheet date serials only when K contains SERIAL. Selecting SERIAL records that you checked the value against its source. Eight-digit values such as 20260901 should use YMD, not SERIAL.

Normalize dates

Enter this formula in L2. It returns a numeric YYYYMMDD date or INVALID:

=IF(COUNTA(A2:J2)=0,"",
 IFERROR(
  LET(
   raw,TO_TEXT(A2),
   s,TRIM(REGEXREPLACE(CLEAN(
      SUBSTITUTE(
       SUBSTITUTE(
        SUBSTITUTE(
         SUBSTITUTE(raw,CHAR(160)," "),
        UNICHAR(8239)," "),
       UNICHAR(8199)," "),
      UNICHAR(8203),"")
     )," +"," ")),
   nativeCandidate,AND(ISNUMBER(A2),A2>0,A2<100000),
   nativeDate,AND(nativeCandidate,EXACT(K2,"SERIAL")),
   orderOK,OR(EXACT(K2,"YMD"),EXACT(K2,"MDY"),EXACT(K2,"DMY")),
   compact,REGEXMATCH(s,"^[0-9]{8}$"),
   separated,REGEXMATCH(s,"^[0-9]{1,4}[-/.][0-9]{1,2}[-/.][0-9]{1,4}$"),
   digits,REGEXREPLACE(s,"[^0-9]",""),
   parts,SPLIT(REGEXREPLACE(s,"[-.]","/"),"/"),
   y,IF(nativeDate,YEAR(A2),
      IF(compact,
         IF(EXACT(K2,"YMD"),VALUE(LEFT(digits,4)),VALUE(RIGHT(digits,4))),
         IF(EXACT(K2,"YMD"),VALUE(INDEX(parts,1,1)),VALUE(INDEX(parts,1,3))))),
   m,IF(nativeDate,MONTH(A2),
      IF(compact,
         IF(EXACT(K2,"YMD"),VALUE(MID(digits,5,2)),
            IF(EXACT(K2,"MDY"),VALUE(LEFT(digits,2)),VALUE(MID(digits,3,2)))),
         IF(EXACT(K2,"YMD"),VALUE(INDEX(parts,1,2)),
            IF(EXACT(K2,"MDY"),VALUE(INDEX(parts,1,1)),VALUE(INDEX(parts,1,2)))))),
   d,IF(nativeDate,DAY(A2),
      IF(compact,
         IF(EXACT(K2,"YMD"),VALUE(RIGHT(digits,2)),
            IF(EXACT(K2,"MDY"),VALUE(MID(digits,3,2)),VALUE(LEFT(digits,2)))),
         IF(EXACT(K2,"YMD"),VALUE(INDEX(parts,1,3)),
            IF(EXACT(K2,"MDY"),VALUE(INDEX(parts,1,2)),VALUE(INDEX(parts,1,1)))))),
   dt,DATE(y,m,d),
   IF(
    AND(
     OR(nativeDate,AND(orderOK,OR(compact,separated))),
     YEAR(dt)=y,
     MONTH(dt)=m,
     DAY(dt)=d
    ),
    VALUE(TEXT(dt,"yyyymmdd")),
    "INVALID"
   )
  ),
  "INVALID"
 ))

For text dates, the component checks reject impossible dates such as September 31. Numeric serials pass only when the value is within the specified range and K contains the exact SERIAL confirmation.

Clean text fields

Enter this formula in M2, then fill it right through Q2. The relative source reference changes from B2 through F2:

=IF(COUNTA($A2:$J2)=0,"",
 LET(
  s,TO_TEXT(B2),
  normalized,
   SUBSTITUTE(
    SUBSTITUTE(
     SUBSTITUTE(
      SUBSTITUTE(s,CHAR(160)," "),
     UNICHAR(8239)," "),
    UNICHAR(8199)," "),
   UNICHAR(8203),""),
  TRIM(REGEXREPLACE(CLEAN(normalized)," +"," "))
 ))

Enter the same pattern in S2, referencing H2, then fill it right through U2:

=IF(COUNTA($A2:$J2)=0,"",
 LET(
  s,TO_TEXT(H2),
  normalized,
   SUBSTITUTE(
    SUBSTITUTE(
     SUBSTITUTE(
      SUBSTITUTE(s,CHAR(160)," "),
     UNICHAR(8239)," "),
    UNICHAR(8199)," "),
   UNICHAR(8203),""),
  TRIM(REGEXREPLACE(CLEAN(normalized)," +"," "))
 ))

These formulas normalize repeated ordinary spaces, ASCII control characters, nonbreaking spaces, narrow nonbreaking spaces, figure spaces, and zero-width spaces. Inspect other unfamiliar source-system characters before approving the import.

Validate and convert amounts

Enter this formula in R2:

=IF(COUNTA($A2:$J2)=0,"",
 LET(
  raw,TO_TEXT(G2),
  s,TRIM(REGEXREPLACE(CLEAN(
     SUBSTITUTE(
      SUBSTITUTE(
       SUBSTITUTE(
        SUBSTITUTE(raw,CHAR(160)," "),
       UNICHAR(8239)," "),
      UNICHAR(8199)," "),
     UNICHAR(8203),"")
    )," +"," ")),
  valid,
   REGEXMATCH(
    s,
    "^(-?\$?([0-9]+|[0-9]{1,3}(,[0-9]{3})+)(\.[0-9]{1,2})?|\(\$?([0-9]+|[0-9]{1,3}(,[0-9]{3})+)(\.[0-9]{1,2})?\))$"
   ),
  IF(
   NOT(valid),
   "INVALID",
   IF(
    LEFT(s,1)="(",
    -VALUE(REGEXREPLACE(s,"[\$(),]","")),
    VALUE(SUBSTITUTE(SUBSTITUTE(s,"$",""),",",""))
   )
  )
 ))

Under the United States locale, this accepts unsigned amounts, leading-minus negatives, optional dollar signs, comma-separated thousands, up to 2 decimal places, and accounting negatives such as (430) or ($430). It rejects malformed strings such as 12abc34.

Negative corrections and refunds remain valid numeric movements. Zero amounts are rejected later because they don’t provide evidence of cash activity.

Add duplicate, label, and category checks

Use this formula in V2 to find duplicate IDs. It escapes wildcard characters in the ID:

=IF(M2="","",
 IF(
  COUNTIF(
   $M$2:$M$10001,
   "="&REGEXREPLACE(M2,"([~*?])","~$1")
  )>1,
  "DUPLICATE",
  ""
 ))

COUNTIF performs this duplicate check without case sensitivity. Resolve IDs that differ only by capitalization against the source system.

Next, use this formula in W2 to flag missing, invalid, or unconfirmed dates:

=IF(COUNTA(A2:J2)=0,"",
 IF(
  OR(
   L2="",
   L2="INVALID",
   AND(ISNUMBER(A2),A2>0,A2<100000,NOT(EXACT(K2,"SERIAL")))
  ),
  "BAD DATE",
  ""
 ))

Use EXACT in X2 to enforce the documented spelling and capitalization:

=IF(COUNTA(A2:J2)=0,"",
 TEXTJOIN(", ",TRUE,
  IF(
   NOT(OR(
    EXACT(N2,"Income"),
    EXACT(N2,"Expense"),
    EXACT(N2,"Transfer In"),
    EXACT(N2,"Transfer Out")
   )),
   "TYPE",
   ""
  ),
  IF(
   NOT(OR(EXACT(T2,"Cleared"),EXACT(T2,"Pending"))),
   "STATUS",
   ""
  ),
  IF(
   NOT(OR(EXACT(U2,"Yes"),EXACT(U2,"No"))),
   "RECONCILED",
   ""
  )
 ))

Then use this formula in Y2 to check expense categories with case-sensitive equality:

=IF(EXACT(N2,"Expense"),
 IF(
  REGEXMATCH(Q2,"[~*?]"),
  "PROHIBITED CATEGORY CHARACTER",
  IF(
   SUM(ARRAYFORMULA(N(EXACT(
    Q2,
    'Income & Expense Report'!$G$5:$G$13
   ))))=0,
   "UNMATCHED CATEGORY",
   ""
  )
 ),
 "")

Enter this approved-category-list audit in AA1:

=LET(
 categories,'Income & Expense Report'!G5:G13,
 cleaned,
  ARRAYFORMULA(
   TRIM(
    REGEXREPLACE(
     CLEAN(
      SUBSTITUTE(
       SUBSTITUTE(
        SUBSTITUTE(
         SUBSTITUTE(categories,CHAR(160)," "),
        UNICHAR(8239)," "),
       UNICHAR(8199)," "),
      UNICHAR(8203),"")
     ),
     " +"," "
    )
   )
  ),
 normalized,ARRAYFORMULA(LOWER(cleaned)),
 hasBlank,SUM(ARRAYFORMULA(N(cleaned="")))>0,
 hasWhitespace,SUM(ARRAYFORMULA(N(categories<>cleaned)))>0,
 hasWildcard,SUM(ARRAYFORMULA(N(REGEXMATCH(cleaned,"[~*?]"))))>0,
 hasDuplicate,COUNTUNIQUE(normalized)<>ROWS(categories),
 IF(
  hasBlank,
  "REVIEW BLANK CATEGORIES",
  IF(
   hasWhitespace,
   "REVIEW CATEGORY WHITESPACE",
   IF(
    hasWildcard,
    "REVIEW CATEGORY CHARACTERS",
    IF(
     hasDuplicate,
     "REVIEW DUPLICATE CATEGORIES",
     "OK"
    )
   )
  )
 )
)

This audit cleans the category labels before checking for blanks and duplicates. As a result, a cell containing only spaces returns REVIEW BLANK CATEGORIES, not OK. It also flags category cells whose raw value differs from the cleaned value.

Finally, enter this row-level decision formula in Z2:

=IF(COUNTA(A2:J2)=0,"",
 IF(OR(
   COUNTBLANK(L2:U2)>0,
   V2<>"",
   W2<>"",
   X2<>"",
   Y2<>"",
   R2="INVALID",
   R2=0,
   AND(ISNUMBER(A2),A2>0,A2<100000,NOT(EXACT(K2,"SERIAL")))
 ),
 "REVIEW",
 "READY"))

Fill L2:Z2 through row 10001. A raw row containing only whitespace remains active, but cleanup exposes the missing fields and gives it REVIEW.

Create a separate sheet named Import_Audit. Put Unmatched categories in A1, then enter this formula in Import_Audit!A2:

=IFNA(
 SORT(
  UNIQUE(
   FILTER(
    Import_Staging!Q2:Q10001,
    Import_Staging!Y2:Y10001="UNMATCHED CATEGORY",
    Import_Staging!Q2:Q10001<>""
   )
  )
 ),
 "No unmatched categories"
)

The qualified ranges ensure that the formula audits Import_Staging, regardless of its destination. When there are no matches, it returns the scalar message No unmatched categories.

The Excel download supports the original manual workflow. This guide doesn’t provide equivalent Excel or Power Query transformations for these staging rules.

The supplied report stops at row 46, so make these changes only in a duplicate workbook.

For a 10,000-row Google Sheets version:

1. Insert 9,971 rows above row 47. The expanded transaction area becomes A18:J10017.
2. Clear the existing synthetic transactions from the expanded area.
3. Update every direct transaction range ending at row 46 so it ends at row 10017.
4. Inspect the formulas in E4:E5, E7:E8, E12:E14, and I5:I13, which are the documented cells using transaction ranges.
5. Keep derived calculation cells such as E6, E9:E11, E15, and J5:J14 intact.
6. Enter the following loader formula in A18.

=LET(
 activeFlags,
  BYROW(
   Import_Staging!A2:J10001,
   LAMBDA(rowData,COUNTA(rowData)>0)
  ),
 allowedDispositionFlags,
  MAP(
   Import_Staging!Z2:Z10001,
   LAMBDA(disposition,
    OR(
     EXACT(disposition,"READY"),
     EXACT(disposition,"REVIEW")
    )
   )
  ),
 hasDispositionFlags,
  MAP(
   Import_Staging!Z2:Z10001,
   LAMBDA(disposition,disposition<>"")
  ),
 missingAllowedDisposition,
  SUM(
   N(activeFlags)*
   (1-N(allowedDispositionFlags))
  ),
 inactiveWithDisposition,
  SUM(
   (1-N(activeFlags))*
   N(hasDispositionFlags)
  ),
 reviewRows,
  COUNTIF(Import_Staging!Z2:Z10001,"REVIEW"),
 IF(
  OR(
   Import_Staging!AA1<>"OK",
   reviewRows>0,
   missingAllowedDisposition>0,
   inactiveWithDisposition>0
  ),
  "",
  IFNA(
   FILTER(
    Import_Staging!L2:U10001,
    Import_Staging!Z2:Z10001="READY"
   ),
   ""
  )
 ))

Keep A18:J10017 otherwise empty so the formula can expand.

The load is all or nothing. The report remains blank when:

• Import_Staging!AA1 doesn’t return OK.
• Any active staging row has REVIEW in column Z.
• Any active raw row lacks an exact READY or REVIEW disposition.
• Any inactive raw row has a value in column Z.

The last 2 checks apply to individual rows. A disposition on an inactive row can’t offset a missing disposition on an active row.

When there are no source rows, the loader returns a scalar blank instead of a filter error. Once the category audit passes and every active row is READY, it returns the cleaned transaction columns from L:U.

Because the loader populates the report range, maintain dropdown values, corrections, status changes, and reconciliation values in Import_Staging. Don’t type inside the populated range.

During each review:

1. Update the as-of date in B6.
2. Add new manual records or replace the staging import.
3. Compare each cleared record with the applicable account statement.
4. Change Reconciled to Yes only after the movement matches.
5. Change a pending record to Cleared only after it occurs.
6. Review E14 and E15.

For a manual report, update Status in column I and Reconciled in column J. For a staged report, update the corresponding raw values in Import_Staging!I:J. The cleaned values in T:U and the loaded report will then refresh.

In the recorded month-end setup, E14 counts in-period cleared records still marked No. Cell E15 displays Review when that count is greater than zero or closing cash is negative.

To reproduce the September status transition, reset the Verification copy from the unchanged Baseline. Then:

1. Change I26 from Pending to Cleared.
2. Change J26 from No to Yes.

This clears and reconciles the $430 Travel expense. Confirm:

E14 remains 1, and E15 remains Review, because another cleared transaction is still unreconciled. Reset the Verification copy again before performing the October check.

No recorded 10,000-row execution or timing benchmark was supplied for this workbook. Before regular use, run this acceptance check on a duplicate containing the dirty 10,000-row CSV your team receives. Preserve its mixed dates, blanks, whitespace, duplicates, and unexpected categories during the test.

Put the acceptance formulas on the separate Import_Audit sheet so they can’t overwrite staging or report data.

Add row-count and disposition controls

Put Active raw rows in Import_Audit!B1, then enter this formula in B2:

=SUM(BYROW(
 Import_Staging!A2:J10001,
 LAMBDA(rowData,N(COUNTA(rowData)>0))
))

This counts each row containing any raw value, including whitespace-only text, once.

Put Active rows without allowed disposition in Import_Audit!C1, then enter this formula in C2:

=LET(
 activeFlags,
  BYROW(
   Import_Staging!A2:J10001,
   LAMBDA(rowData,COUNTA(rowData)>0)
  ),
 allowedDispositionFlags,
  MAP(
   Import_Staging!Z2:Z10001,
   LAMBDA(disposition,
    OR(
     EXACT(disposition,"READY"),
     EXACT(disposition,"REVIEW")
    )
   )
  ),
 SUM(
  N(activeFlags)*
  (1-N(allowedDispositionFlags))
 )
)

Cell C2 must return 0.

Put Inactive rows with disposition in Import_Audit!D1, then enter this formula in D2:

=LET(
 activeFlags,
  BYROW(
   Import_Staging!A2:J10001,
   LAMBDA(rowData,COUNTA(rowData)>0)
  ),
 hasDispositionFlags,
  MAP(
   Import_Staging!Z2:Z10001,
   LAMBDA(disposition,disposition<>"")
  ),
 SUM(
  (1-N(activeFlags))*
  N(hasDispositionFlags)
 )
)

Cell D2 must also return 0.

Put Review rows in Import_Audit!E1, then enter this formula in E2:

=COUNTIF(Import_Staging!Z2:Z10001,"REVIEW")

Resolve every issue against the source data until E2 returns 0. The loader also requires Import_Staging!AA1 to return OK.

Add month-end control totals

Enter these exact Type criteria in Import_Audit!F1:I1:

Enter this formula in Import_Audit!F2, then fill it right through I2:

=SUMIFS(
 Import_Staging!$R$2:$R$10001,
 Import_Staging!$N$2:$N$10001,F$1,
 Import_Staging!$T$2:$T$10001,"Cleared",
 Import_Staging!$Z$2:$Z$10001,"READY",
 Import_Staging!$L$2:$L$10001,">="&'Income & Expense Report'!$B$4,
 Import_Staging!$L$2:$L$10001,"<="&'Income & Expense Report'!$B$5
)

Each cell tests one exact intended Type separately. Rows reach READY only after the case-sensitive Type and Status checks pass.

For the month-end setup where B6 equals B5, compare:

Also confirm:

• Category actuals in I14 equal cleared expenses in E5.
• Closing cash equals opening cash plus net operating cash plus Transfer In minus Transfer Out.
• Rows dated exactly on B4 and B5 are included.
• Rows before B4 or after B5 don’t affect the period totals.

The supplied execution evidence covers month-end reporting only. Keep B6 equal to B5 for these acceptance controls.

Check dirty-data behavior

In a separate acceptance copy, confirm that:

• Raw dates remain text unless they are confirmed native date serials.
• Every text date has an exact YMD, MDY, or DMY value in column K.
• A blank or invalid date order produces INVALID in L, BAD DATE in W, and REVIEW in Z.
• A numeric date serial without exact SERIAL confirmation receives REVIEW.
• An impossible date such as 20260931 receives REVIEW.
• 1,234.56 becomes the numeric value 1234.56.
• (430) becomes -430.
• 12abc34 becomes INVALID.
• A zero amount receives REVIEW.
• A whitespace-only raw row remains active and receives REVIEW.
• Lowercase controlled labels such as income or cleared receive REVIEW.
• Duplicate IDs are reported even when they contain *, ?, or ~.
• Duplicate IDs are resolved against the source system rather than deleted automatically.
• Expense categories containing *, ?, or ~ receive REVIEW.
• An expense category not found in G5:G13 appears in the unmatched-category report.
• A category cell containing only spaces makes AA1 return REVIEW BLANK CATEGORIES.
• A category with leading or trailing whitespace makes AA1 return REVIEW CATEGORY WHITESPACE.
• Category names differing only by capitalization make AA1 return REVIEW DUPLICATE CATEGORIES.
• An empty import returns a blank report area rather than a filter error.
• Matching Transfer Out and Transfer In rows affect E7:E9 but not operating or category totals.
• A negative correction using the original Type and Category reverses the applicable amount without overwriting the reconciled source row.
• A row below the expanded range is excluded until every affected staging, loader, and report range is extended.

Keep the formulas bounded to the required capacity. Check recalculation, filtering, scrolling, and editing responsiveness in the browser, spreadsheet application, and hardware your team uses. The 10,000-row range defines capacity. It isn’t evidence of a performance result.

If the source exceeds 10,000 rows, extend the staging, report, loader, audit, and control ranges together. Then rerun every acceptance check.

ModelMonkey can inspect spreadsheet ranges and help identify inconsistent labels or formula errors in Google Sheets or Excel. For this workflow, use a read-only request such as:

Without changing cells, inspect Import_Staging!A2:AA10001,
Import_Audit!A1:I2, and the 'Income & Expense Report' sheet.

Report:
- active raw rows in A:J without an exact READY or REVIEW result in Z
- inactive raw rows in A:J that have any value in Z
- active rows with missing cleaned fields in L:U
- duplicate cleaned record IDs in M
- INVALID or blank normalized dates in L
- text-date rows whose K value is not exactly YMD, MDY, or DMY
- numeric native-date serials whose K value is not exactly SERIAL
- values outside the documented Type, Status, and Reconciled lists
- Expense categories in Q that do not exactly match G5:G13
- blank, whitespace-only, or duplicate category labels in G5:G13
- category labels containing *, ?, or ~
- zero or nonnumeric cleaned amounts in R
- rows marked REVIEW in Z
- formula errors in the report summary
- any difference between cleared expenses in E5 and category actuals in I14

Give the row or cell address for every finding. Do not correct source
records or remove duplicates.

Review each finding against source records and account statements. If you ask ModelMonkey to correct cells, review the proposed changes when the workflow presents a preview. Spreadsheet assistance doesn’t replace reconciliation or guarantee that every result is correct.

Monthly rollover is manual. Finish reconciling the current month, archive a copy, and record the verified closing cash from E9.

To reproduce the recorded October continuation case, reset the Verification copy from the unchanged September Baseline. Set:

• B4 to 20261001
• B5 to 20261031
• B6 to 20261031
• B7 to 10935

For this independent check, retain the September plans:

• Leave B8 at 14000.
• Leave B9 at 9500.
• Leave H5:H13 unchanged.

The retained category plans are:

Cell H14 should remain $9,500.

Enter this complete record in A30:J30:

20261002 | R-013 | Income | Operating checking | Harbor Client | Revenue | 1500 | Project deposit; bank transfer | Cleared | Yes

The exact cells are:

The October date criteria exclude the retained September transactions. Opening cash is carried into B7 once, so the old transactions aren’t counted again.

Confirm:

The closing-cash check is:

$10,935 opening cash + $1,500 cleared income = $12,435

For an actual rollover, replace the retained September plans with the new month’s values in B8:B9 and H5:H13. The workbook doesn’t carry balances forward automatically or connect to a bank account.