Mini-App · Accounting
QuickBooks profit and loss report by month, from your transactions
For small business owners and bookkeepers who use QuickBooks and want a clear month-by-month view of profit. Upload a Transaction Detail by Account CSV export, or one export per month, with Date, Account and Amount columns.
You get a profit and loss table with each income and expense account by month, plus Total Income, Total Expenses, Net Profit and a period total. A bar chart compares net profit across months.
- 1Choose the fileNot chosen yet
- 2Check the valuesNothing to change
- 3Run and get the resultFree
1QuickBooks transaction detail export
No file yet · needs Date, Account, Amount
Runs the app’s saved steps, no AI. A file missing a column is not run or charged.
3Result
Choose your file and press Run — the result shows here, like the sample below.
What it makes, on a sample file
Summed Amount by Account and month (YYYY-MM) after dropping balance-sheet accounts matching the pattern list (excluded: none found). Accounts matching the income patterns are labelled Income, the rest Expense. No sign flip was needed: income was already positive and expenses negative. Net Profit = Total Income + Total Expenses.
- Total Income$1,361,782
- Total Expenses-$886,564
- Sales of Product Income$818,688
- Services$543,093
- Net Profit$475,218
- Cost of Goods Sold-$282,720
- Payroll Expenses-$254,137
- Advertising & Marketing-$108,175
| Account | Type | 2025-07 | 2025-08 | 2025-09 | 2025-10 | 2025-11 | 2025-12 | 2026-01 | 2026-02 | 2026-03 | 2026-04 | 2026-05 | 2026-06 | 2026-07 | 2026-08 | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sales of Product Income | Income | 51,560.57 | 74,688.58 | 50,445.76 | 55,495.66 | 57,447.98 | 103,337.6 | 53,514.46 | 26,961.95 | 28,220.69 | 60,415.5 | 81,859.81 | 62,695.64 | 44,492.55 | 67,551.66 | 818,688.41 |
| Services | Income | 45,487.85 | 33,364.38 | 17,557.46 | 14,511.35 | 72,868.92 | 56,058.14 | 51,149.35 | 20,042.42 | 48,438.23 | 31,295.09 | 33,519.04 | 43,982.74 | 38,431.84 | 36,386.65 | 543,093.46 |
| Total Income | Subtotal | 97,048.42 | 108,052.96 | 68,003.22 | 70,007.01 | 130,316.9 | 159,395.74 | 104,663.81 | 47,004.37 | 76,658.92 | 91,710.59 | 115,378.85 | 106,678.38 | 82,924.39 | 103,938.31 | 1,361,781.87 |
| Advertising & Marketing | Expense | -9,791.85 | -6,565.35 | -10,555.1 | -7,155.31 | -6,300.82 | -5,298.94 | -10,868.8 | -2,979 | -7,979.97 | -8,567.21 | -4,363.25 | -9,555.46 | -5,074.62 | -13,119.09 | -108,174.77 |
| Cost of Goods Sold | Expense | -24,482.07 | -24,611.76 | -20,291.63 | -11,229.6 | -23,882.85 | -22,254.49 | -25,780.57 | -3,497.88 | -23,017.72 | -14,577.38 | -22,961.62 | -18,088.18 | -24,730.85 | -23,313.64 | -282,720.24 |
| Payroll Expenses | Expense | -17,559.62 | -18,711.87 | -18,215.91 | -17,810.14 | -18,314.88 | -18,130.53 | -17,854.66 | -18,492.22 | -18,162.59 | -18,309.35 | -17,964.24 | -17,885.36 | -18,596.73 | -18,129.11 | -254,137.21 |
| Rent & Lease | Expense | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -5,200 | -72,800 |
| Software & Subscriptions | Expense | -3,779.13 | -2,522.4 | -4,196.48 | -5,678.85 | -3,979.43 | -3,419.38 | -2,444.01 | -5,903.88 | -2,397.02 | -2,922.48 | -3,767.2 | -4,430.78 | -3,273.84 | -2,389.95 | -51,104.83 |
| Travel | Expense | -1,629.32 | -4,032.65 | -2,664.66 | -3,406.65 | -7,901.64 | -2,872.02 | -5,778.41 | -4,315.12 | -2,964.64 | -6,977.2 | -4,637.38 | -5,786.64 | -3,524.17 | -2,425.91 | -58,916.41 |
| Utilities | Expense | -2,855.86 | -5,193.52 | -5,607.72 | -4,800.11 | -2,420.8 | -4,535.05 | -3,169.35 | -7,536.15 | -2,358.93 | -3,586.34 | -4,938.21 | -3,977.66 | -3,746.81 | -3,984.3 | -58,710.81 |
| Total Expenses | Subtotal | -65,297.85 | -66,837.55 | -66,731.5 | -55,280.66 | -68,000.42 | -61,710.41 | -71,095.8 | -47,924.25 | -62,080.87 | -60,139.96 | -63,831.9 | -64,924.08 | -64,147.02 | -68,562 | -886,564.27 |
| Net Profit | Subtotal | 31,750.57 | 41,215.41 | 1,271.72 | 14,726.35 | 62,316.48 | 97,685.33 | 33,568.01 | -919.88 | 14,578.05 | 31,570.63 | 51,546.95 | 41,754.3 | 18,777.37 | 35,376.31 | 475,217.6 |
What your file needs
QuickBooks transaction detail export, one row per record, with these columns (named differently is fine — the app asks which column is which):
DateAccountAmountHow to use it
- 1In QuickBooks, run the Transaction Detail by Account report for the months you want. Export it as CSV. If you have one export per month, upload them all and they will be combined.
- 2Check that the file has Date, Account and Amount columns, with one transaction per row.
- 3Bank, credit card, loan, receivable, payable, equity and other balance-sheet accounts are left out automatically. The method note lists which accounts were left out.
- 4Read the table from top to bottom: income accounts and Total Income, then expense accounts and Total Expenses, then Net Profit. Each month is a column, and the last column is the total for the whole period.
- 5Use the bar chart to compare net profit across months. The chart title shows the overall total and the best month.
Common questions
Which QuickBooks report should I export?
Run the Transaction Detail by Account report for the months you want and export it as CSV. If you have one export per month, upload them all and they will be combined into one table.
What if my columns are named differently?
The file needs a Date, an Account and an Amount column, with one transaction per row. If your export uses slightly different names, rename those headers to Date, Account and Amount before you upload.
Why are some accounts missing from the table?
Bank, credit card, loan, receivable, payable, equity and other balance-sheet accounts are left out automatically because they are not part of profit and loss. The method note lists every account that was left out so you can check it.
What does it cost, and is my data kept private?
Each run costs 1 credit. Your file is used only to build your profit and loss table and is not shared with anyone.