Upload Troubleshooting

Something looks off? This is the page for that. Not because you failed — but because Money Mastery is doing a lot for you, and one small wrong click can make the next screen look confusing.

FAQ Find your problem, fix it safely Personal & Business
Before Anything Else
If you accidentally typed or pasted somewhere wrong — undo immediately.

Not after checking three other tabs. Not after trying to clean it up. Not after deleting rows to compensate. Immediately.

Ctrl + Z Windows
⌘ + Z Mac

First Check: 5 Questions That Solve Most Problems

Before you go hunting for a complicated answer, check these five things. A surprising number of problems come from exactly one of them.

1 Am I signed into the correct Google account?
2 Did the data actually get uploaded?
3 Did I move it into the correct account tab?
4 Did I categorize it?
5 Did I accidentally paste or add the same month twice?
No problems match your search. Try a different term.
Access, Registration & Google Permissions 8 topics
Problem Google says "This app isn't verified"
What this usually means

Nothing bad. This is the normal Google warning shown for private scripts built for Money Mastery users rather than released as a public app.

What to do
  1. Click Continue
  2. Choose the correct Google account
  3. Click Advanced
  4. Click the link that says Go to [tool name] (unsafe)
  5. Continue through the permissions flow
  6. If you see Select All, use it
Do not
  • Do not click Back to safety
  • Do not close the window halfway through
  • Do not assume the warning means the system is unsafe
Problem I clicked START HERE and nothing seems to happen
What this usually means

The permission flow did not finish, you are in the wrong Google account, or the auth session got interrupted.

What to do
  1. Refresh the sheet
  2. Click START HERE again
  3. Make sure you are signed into the same Google account tied to your purchase
  4. If a permissions screen appears, complete it fully
If it still fails, use support rather than trying random structural fixes.
Problem It says it cannot determine my email / I can't register
What this usually means

Google is not giving the sheet permission to identify the signed-in user, or you are in the wrong browser account.

What to do
  • Confirm you are signed into Google in that browser
  • Confirm it is the same Google account tied to your Money Mastery access
  • Re-run the permissions flow if needed
Problem My access key is not working
What this usually means
  • The key was typed incorrectly
  • Extra spaces were copied with the key
  • The wrong Google account is being used
  • The key belongs to a different system
  • The sheet has not fully synced registration state yet
What to do
  • Copy the key again exactly as it appears — no extra spaces
  • Confirm you are in the correct Google account
  • Confirm you are in the correct Personal or Business file
Problem My PIN is not accepted / my PINs don't match
What this usually means

The registration flow expects a 4–6 digit numeric PIN.

What to do
  • Make sure the PIN is numbers only
  • Make sure it is at least 4 digits
  • Make sure both entries match exactly
Problem I don't have an access key
What this usually means

You may be a guest, not the primary owner.

What to do

If you are not the account owner, ask the owner to add you as a guest from the Money Mastery menu rather than registering as the primary user.

Problem The navigation menu doesn't appear after I authorized
What this usually means

Sometimes a VPN or browser interference blocks the menu display even though permission succeeded.

What to do
  • Try turning the VPN off temporarily
  • Refresh the sheet
  • Use the hamburger menu (☰) if available while you sort it out
Problem It says my account is disabled
This is not a normal setup hiccup. It means the system flagged the account for restricted access. Stop there and contact support. This is not something to fix by editing the sheet.
Account Upload Center & File Import 10 topics
Problem I can't load my accounts in the Account Upload Center
What this usually means

The Upload Center could not load the available account tabs for that file.

What to do
  • Refresh the sheet and wait a moment, then retry
  • Make sure the Upload Center file opened fully
  • Confirm you are not in the wrong file entirely
Problem The file won't upload
What this usually means

Wrong file type, file too large, browser failed to read it, or a damaged bank export.

What to do

Use only supported file types: CSV, .xls / .xlsx, or PDF. If rejected, download a fresh export directly from your bank and try again.

Problem File too large
Current practical limits
  • PDF — up to ~50 MB; processing warnings above the mid-40 MB range
  • Excel — around 20 MB
  • CSV — around 10 MB
What to do
  • Download a smaller date range
  • Split the file into smaller chunks if needed
  • Use CSV instead of PDF when possible — it is always the cleaner path
Problem My PDF import failed
Common causes
  • The PDF is password-protected
  • The PDF is unusually large
  • The layout is hard to extract cleanly
  • The bank's PDF format is not import-friendly
What to do
  • Download CSV or XLSX from your bank instead, if available
  • Make sure the PDF is not password-protected
  • Try a smaller statement date range
  • If the PDF is huge, split it into smaller files
PDF is supported, but CSV / Excel is the cleaner path whenever your bank offers it.
Problem My CSV / Excel import looks wrong
What this usually means
  • The bank export included extra metadata rows
  • Signs are reversed
  • The wrong account type was chosen
  • The file is using an unusual format
What to do
  • Compare the review screen to the original statement
  • If signs are reversed, check the Account Type setting
  • For credit cards → use Flipped Account
  • For checking/debit → use Traditional Account
  • If the file came from Excel, try saving as CSV UTF-8 first
Problem My expenses are showing as positive numbers
What this usually means

This is one of the most common upload issues. The source is almost always a credit card export, or the account was imported as Traditional when it needed Flipped Account.

Account type guide
  • Traditional Account — income positive, expenses negative. Use for most checking / debit / bank accounts.
  • Flipped Account — expenses positive, income negative in the source file. Use for many credit card exports.

If you are already on the review screen and everything is backward, use ± Reverse All Signs.

Older instructions may say "use the Flipped? option." The current system expresses that as choosing Flipped Account in the upload setup.
Problem The imported transactions look incomplete
Possible causes
  • The file did not contain the full date range
  • The AI missed some lines
  • Some transactions were filtered as summaries or duplicates
  • The wrong account statement was used
What to do

At the review screen: compare against the original statement, use Add Line for missing transactions, and remove anything that does not belong. Do not click Add These Transactions until the review table looks right.

Problem The imported transactions look duplicated
Possible causes
  • The statement overlapped a period already imported
  • The month was imported twice
  • A duplicated row made it through the source file
What to do

Before approving: compare the review screen against your statement and remove obvious duplicates. After importing into the Upload Center: use the teal first row and gold last row markers to identify exactly what was just added, then copy only that block into your real system.

Problem The import says "Please review before submitting"
That is not an error — it is a warning. The AI read the data and you are expected to confirm dates, descriptions, amounts, missing lines, and duplicated lines before anything is saved.

Treat the review screen as the final checkpoint. Nothing is committed until you approve it.

Problem The wrong bank or wrong file type was chosen

The system may still work, but extraction quality may suffer.

What to do
  • Choose the correct File Type
  • Choose the correct Bank if known
  • Confirm the correct Account Type
  • Retry with a fresh file if needed
Moving Data From Upload Center Into Your System 5 topics
Problem I pasted the wrong data into my Personal or Business sheet
If it just happened

Press Ctrl + Z / ⌘ + Z immediately.

Then redo the move carefully
  1. Copy only the teal-to-gold block from the Upload Center
  2. Move to the correct account tab
  3. Click the first empty cell in Column C
  4. Use Paste values only (Ctrl + Shift + V / ⌘ + Shift + V)
Problem I pasted into the wrong account tab
If it just happened

Undo immediately: Ctrl + Z / ⌘ + Z.

If the paste is already embedded and Undo is no longer safe: stop editing, document what happened, and use support or the official correction process. Do not start deleting random rows to "move it over."
Problem I pasted with formatting and the sheet looks weird
If it just happened

Undo immediately, then re-paste using Paste values only.

Safer paste shortcuts
  • Windows: Ctrl + Shift + V
  • Mac: ⌘ + Shift + V
Problem The month looks duplicated in my account tab
What this usually means
  • A month that was already there was pasted again
  • You copied more than the newest upload block
  • The same block was pasted twice
What to do

Compare your latest pasted section to the rows already there. Use the Upload Center's teal first row / gold last row markers to identify only the newest batch before copying.

Best habit: Before each new upload, note exactly where your current data ends. That tells you where the next block should begin.
Problem I cleared data by deleting rows
Stop there. Row deletion can create bigger structural problems than the original paste mistake. Do not keep improvising.
What to do

Use support or the official correction workflow rather than attempting your own repair.

Categorization Problems 6 topics
Problem I don't know whether to use Personal or Business / Special Label
Ask yourself
  • Is this telling a personal money story? → Personal Category
  • Is this telling a business money story? → Business / Special Label
  • Is this not a normal category at all? (transfer, credit card payment, refund) → Special Label
Problem I categorized something wrong

This is a normal human judgment call, not a system failure.

What to do

Correct the row directly in the categorization workflow. The system gets smarter from truth, not from keeping a bad decision consistent.

Problem I'm not sure whether something is a Need or a Desire
Do not freeze. Choose the most honest answer and stay consistent with similar future transactions. The goal is better awareness, not philosophical perfection.
Problem My reports still show lots of uncategorized activity
What to do

Return to categorization and finish labeling every row:

  • Category
  • Business / Special Label where applicable
  • Need / Desire where applicable
  • Memo only where useful
Problem I used a normal category for a transfer or credit card payment
These are not just naming issues — they change how totals behave.
What to do

Use the proper special labels for: transfers, credit card payments, ignored rows, refunds / return workflows, and split transactions.

Problem I manually used "Split Transaction" like a normal category
Do not use Split as a normal category placeholder.
What to do

Use the official split workflow instead of typing the label manually.

Dashboard, Overview & Report Problems 7 topics
Problem My Dashboard shows "No data"
Check these four things in order
  1. Was the data uploaded?
  2. Was it pasted into the correct account tab?
  3. Was it categorized?
  4. Are you looking at the correct filter period?
Problem The Dashboard numbers feel wrong
What this usually means

The Dashboard is reflecting incomplete or mis-labeled source data.

Check
  • Recent uploads complete?
  • Data in the correct account tabs?
  • Categories complete?
  • Transfers / debt payments / ignored rows labeled correctly?
  • Any duplicated months?
Do not over-interpret the chart before checking the underlying transactions.
Problem My top expense numbers seem weirdly low or high
What this usually means

Debt payments and transfers are tracked separately from ordinary expenses, which changes what appears in standard expense views.

Check whether
  • The category really belongs in normal expenses
  • It should be a special label instead
  • It is being surfaced in Other Transactions / Payments views
Problem Monthly Overview shows zero or incomplete data
Check three things
  1. Was the data uploaded?
  2. Was it pasted into the correct account tab?
  3. Was it categorized?

That solves a huge percentage of "missing month" problems.

Problem Yearly Overview looks wrong
Check
  • All months uploaded?
  • Pasted into correct account tabs?
  • Categorized consistently?
  • Special labels used correctly?
  • Duplicates removed?

The Yearly Overview is only as accurate as the uploads and labels beneath it.

Problem My Profit & Loss doesn't match what I expected
Possible causes
  • Missing transactions
  • Incorrect business categorization
  • Ordinary categories used where special labels were needed
  • Relying on adjustment areas instead of fixing source data
What to do

If the full system needs to reflect the correction, fix it in the actual account tab, not only in a P&L adjustment area.

Problem I made a P&L adjustment but Yearly Overview didn't change
That is expected behavior. P&L adjustments do not automatically rebuild the Yearly Overview totals.
What to do

If you need the full system to reflect the missing item, add or correct the transaction in the real account data. Do not rely only on the P&L adjustment area.

Savings Problems 4 topics
Problem My savings goals are not showing on the Dashboard
What this usually means

The Dashboard only shows active savings funds that have a real yearly goal and are not marked completed.

Check the Savings sheet
  • Does the fund have a yearly goal?
  • Is it marked completed by mistake?
  • Does it have a priority number?
  • Is there a current saved amount?
Problem My savings goals are out of order on the Dashboard
What to do

Update the priority number in the Savings sheet. Lower numbers rise higher on the Dashboard.

Problem A completed savings goal still feels active
What to do

Mark the goal Completed in the Savings sheet. The Dashboard filters out completed goals so they stop appearing as active funds.

Problem The Dashboard's "Net Savings" line doesn't match my manually entered goal
That is normal.

The Dashboard savings area has two different layers: your Savings sheet goals (what you planned) and your actual net savings / surplus data for the selected period (what your money flow made possible). The net savings line reflects actual financial activity, not just your planned number.

Sheet-Editing Mistakes & Structural Problems 5 topics
Problem I typed in the wrong place on the sheet
Do immediately

Press Ctrl + Z / ⌘ + Z and stop editing until you are sure it is reversed.

Do not
  • Keep typing
  • Delete surrounding rows
  • Try to reconstruct formulas manually
Problem I overwrote a formula
What to do
  1. Undo immediately if possible
  2. If not, stop editing that section
  3. Take a screenshot
  4. Document what you changed
  5. Use support instead of guessing the formula
Problem I renamed a tab
You changed structural navigation rather than using the intended naming field. Do not continue renaming manually.
What to do

If the system has a designated naming cell, use that method instead. If the rename caused visible confusion, stop and document it for support.

Problem I deleted rows to clean something up
Stop there. Deleting rows is one of the easiest ways to turn a small issue into a larger workbook issue — removing formulas, shifting ranges, disconnecting reporting logic.
What to do

Use support or the official correction workflow rather than continuing to improvise.

Problem I pasted with formatting and now the sheet looks weird
What to do
  • If recent: Undo immediately (Ctrl + Z / ⌘ + Z)
  • Re-paste using Paste values only (Ctrl + Shift + V / ⌘ + Shift + V)

When to Stop and Ask for Help

Use the support process instead of random fixes when:
  • You overwrote a formula and can't undo it safely
  • You deleted rows and are not sure what shifted
  • The wrong month was pasted and Undo is no longer clean
  • Registration / access is failing after correct permissions
  • The Dashboard or reports still look wrong after uploads, paste, and categorization are confirmed
  • You are seeing account-disabled or access-restricted messages
  • Something feels structurally broken, not just incomplete
Before Contacting Support
Send something useful. Capture all of this:
  • The name of the sheet / tab
  • What you were trying to do
  • What you clicked or pasted
  • Whether it was CSV / Excel / PDF
  • Whether it was Personal or Business
  • The exact warning or error message
  • A screenshot
  • Whether you already tried Undo

"Most problems in Money Mastery are recoverable. The real danger usually isn't the original mistake — it's the five panicked fixes that happen after it."

So if something looks wrong:

The Safe Response
  • Pause
  • Undo if it just happened
  • Check the basic five questions
  • Go back to the underlying data
  • Use support before experimenting with structural repairs

That is how you keep a small problem small.

Related Article
What Not to Edit