How to review a FOP income spreadsheet in Google Sheets before filing: dates, formulas, missing payments, duplicate imports, and manual corrections.
Reviewing FOP income records in Google Sheets involves more than checking the final total. Even a correct result does not prove that every payment reached the spreadsheet, every date was interpreted correctly, or every manual change can be explained. A final amount may still look convincing when a new row falls outside the calculation, part of a bank statement was never transferred, or a value is stored as text.
Single-tax FOPs in groups 1–2 and group 3 FOPs without VAT may keep monthly income records in a free-form electronic format. Google Sheets can therefore serve as a working FOP income ledger. Different form requirements apply to group 3 FOPs registered for VAT and to FOPs under the general tax system. Reliability depends on whether you can repeat the review and trace the data to its source. The ten tests below assess the current process but do not replace tax advice.
Work on a copy. Do not alter working data for an experiment, and do not send bank statements to unknown third-party services. A small sample checked against the original source is enough for each test. If you find a discrepancy, preserve the evidence and reason before changing the data.
A familiar situation: the spreadsheet has new entries, but the total has not changed. In a copy, add one temporary record with a small known amount and compare the change in the total. The difference should equal that amount exactly, without a manual adjustment to the result.
If the record is ignored, the source range or calculation may still cover only older rows. Check whether new entries are included, then return the copy to its original state. The appearance of the last populated row does not prove that the row participates in the total.
An amount can display a hryvnia sign and resemble the surrounding values while being excluded from addition. In a copy, find a pasted or imported entry, compare it with the source, and check whether it changes the total. Applying a currency format does not turn text into a number.
Spaces, text values, and the wrong decimal separator may come from the source format or locale. The warning sign is an amount that a calculation ignores or interprets differently. Confirm the source format and normalize the value. Do not remove a comma or period blindly and risk losing the decimal part.
Review several records with an ambiguous date such as 03/04. For each operation, compare the day and month with the bank statement or another primary source. Do not infer the order from the cell's appearance alone: the same sequence can be interpreted differently depending on locale and import method.
A problem may place an operation in the wrong month or sort it somewhere unexpected. Confirm the source format and file settings before correcting the interpretation. This test is about the date value itself. The next test deals with reporting-period boundaries.
Compare source operations immediately before the required month or quarter, on its first day, on its last day, and immediately after the period ends. If records contain a time, review late-evening receipts on the final day separately.
A problem exists when the report omits a payment inside the selected interval or includes an operation from the next period. That alone does not prove a tax error, but it makes the total unreliable. Review the date conditions and time values. Do not force the expected total by manually adding or excluding a row without fixing the cause.
Select several operations by bank ID or another stable identifier. After sorting, compare each operation's date, amount, payer, and payment purpose with the primary source. Sorting only one column can break the relationships between fields while leaving the overall total unchanged.
The warning sign is a correct amount beside the wrong date or payer. Restore the data from a reliable version and sort the entire related range in the future. Do not rebuild relationships from matching amounts because separate legitimate payments can have the same value.
A suspicious row may display a familiar result but use a different calculation method. Open the calculated cell in a copy and compare it with neighboring cells through the formula bar. Check for an empty cell or a fixed number entered where a calculation is normally expected.
The same appearance does not prove the same origin. First determine whether the manual change was an intentional exception and what supported it. If the replacement was accidental, restore the consistent calculation. Do not fill a formula down the entire column until you have reviewed legitimate exceptions.
This test applies only when you receive foreign-currency payments. Choose one historical operation and check whether the spreadsheet identifies the official rate source and its date. Compare both with the rule that applies to your circumstances and with the source's historical data.
There is a problem if only an unexplained number remains or a past operation uses today's rate. Do not replace it with the current rate by guesswork. Reconstruct the source, date, and basis first. If you have no foreign-currency receipts, the honest result for this test is not applicable.
Start reconciling the FOP income spreadsheet with bank statements by listing every account and source used in the selected period, then compare that list with what was transferred into the spreadsheet. Match the statement periods, check the beginning and end of each one, and sample several real transactions from every source.
A formula can work perfectly while missing data that never entered the file. Fill confirmed gaps, then assess the purpose of each receipt separately. Do not treat every bank credit as taxable income automatically. For the classification of ordinary and complex operations, use the separate guide to FOP income from a bank statement.
If you imported several bank statements with overlapping periods, check whether a repeated import created duplicates. Review the records at the boundaries of the exports and compare bank identifiers, the account, payment purpose, and other source details. A matching date and amount alone do not prove duplication because two separate payments may be identical.
The warning sign is one bank operation with the same stable identifier repeated because of an import. Remove a row only after confirming that fact, and preserve an explanation of the change. Automatically deleting every match by amount can remove genuine receipts. Refunds are outside this test.
Choose a recent correction and recover three things: the original value, the reason for the change, and the document or source that supports it. Version history, a comment, or a separate document may help. A cell's edit history does not show every change, so one mechanism may not be sufficient.
If the explanation exists only in someone's memory, the next reconciliation depends on that person. Record the basis for the correction and preserve the source data. This test concerns traceability, not the presence of a formula: even a valid manual correction should remain understandable later.
Google Sheets may be enough when there are few records, the sources are clear, and you regularly reconcile transfers, dates, and changes. There is no universal transaction threshold. What matters is whether you can complete these checks without gaps and still explain the result a month or quarter later.
Automation becomes more useful with several accounts, foreign-currency receipts, repeated statement transfers, and a growing amount of time spent on the same reviews. It does not eliminate oversight, but it can remove part of the recurring data collection and calculation work.
MYFOP UA collects receipts from connected PrivatBank and monobank accounts, converts foreign-currency receipts using the rate for the receipt date, helps calculate taxes, and shows deadlines. You can also review current dates in the tax calendar. The service does not inspect your Google Sheet, protect its formulas, support every bank, or file a return on your behalf.
| Situation | Google Sheets | Automation |
|---|---|---|
| Data sources | One or a few simple, understood sources | Several connected accounts with recurring collection |
| Foreign currency | Occasional operations with documented rates | Recurring conversion by receipt date |
| Review | You complete it consistently by hand | Repeated reconciliation takes increasing time |
| Control | Depends on your discipline and change history | Manual review is still needed for exceptions |
These short answers help you decide what to do after the diagnostic review without building another complicated process around the spreadsheet.
A group 3 FOP without VAT may keep monthly income records in a free-form electronic format. Google Sheets can be a practical tool when data is supported by source records and reconciled regularly. Separate form requirements apply to group 3 FOPs registered for VAT.
Reconcile every account and the full reporting period with bank statements, then check dates, numeric formats, exchange rates, repeated imports, and manual corrections. Transfer the total to the return only after every discrepancy has been understood.
A matching amount alone does not prove a duplicate. Remove a record only after a stable identifier and source details confirm that the same operation was imported twice.
When the number of sources grows, foreign-currency operations appear, transfers repeat, and regular reconciliation consumes disproportionate attention.
After the ten tests, reconcile the reviewed spreadsheet total for the reporting period with the income amount you plan to transfer to the return. Record the tests that did not pass, resolve simple causes, and repeat the review on a copy. If the main burden comes from collecting payments, converting currency, and tracking deadlines rather than from one complicated spreadsheet, compare your manual process with MYFOP UA.
See how MYFOP UA works with connected accounts, receipts, tax calculations, and deadlines.
How to calculate group 3 FOP income from a bank statement: 25 rows, 12 cases, foreign currency, fees, refunds, own transfers, and a full reconciliation.
Read articleMYFOP UAHow MYFOP UA collects income from PrivatBank and Monobank, converts foreign-currency payments to UAH, calculates 3rd group FOP taxes, and shows deadlines and payment accounts.
Read articleTaxesA concise overview of what is currently included: single tax, military levy, SSC, and tax return deadlines for 3rd group FOPs in Ukraine.
Read article
