Guide-linked quiz · Easy Level
How to Categorize Your Bank Transactions With AI Quiz
Tests preparing and redacting a bank CSV, reading cryptic merchant descriptors, excluding transfers, and checking row counts and totals.
Question 1 of 8
Which columns does the guide recommend keeping before you upload a bank export to a chatbot?
Preview every question8 questions
Answers and explanations appear as you take the quiz.
- Which columns does the guide recommend keeping before you upload a bank export to a chatbot?
- Date, description and amount
- Account number, balance and amount
- Name, address and description
- Every column the bank provides
- Why choose a fixed category list before asking the AI to sort transactions?
- It makes the file smaller
- The bank requires it
- Otherwise the model may invent near-duplicates like Food, Restaurants and Dining
- Chatbots cannot read category names
- A transaction reads 'SQ *BLUE DOOR'. What does the 'SQ *' prefix most likely tell you?
- That the charge is a subscription
- That the payment processor was Square, not what kind of business it is
- That it is a charge based on square footage
- That the line is a refund
- Why should a credit card payment from your checking account usually be left out of spending totals?
- It is always a fee
- Banks hide it from exports
- It counts as income
- The purchases on the card are already counted, so including the payment counts them twice
- How should the AI handle an unclear Amazon charge?
- Label it Groceries
- Delete the row
- Mark it Needs review so you can decide
- Split it evenly across all categories
- Which check confirms that the AI did not drop or merge any rows?
- The row count and category totals match the original file
- The categories are in alphabetical order
- The file opens without errors
- The file has a Category column
- For a file with thousands of transactions, why is a code-running data analysis tool more reliable than pasting text into a chat?
- It connects directly to your bank
- It removes account numbers automatically
- It guarantees correct categories
- It applies logic to every row instead of rewriting long text that can skip lines
- What is the advantage of asking the AI for keyword rules instead of only categories?
- Rules hide merchant names
- Rules can be reapplied to next month's export for consistent results
- Rules make the bank categorize for you
- Rules remove the need to check totals
Keep testing yourself
More quizzes picked for your level.