CAT Accounting Technician Software & Technology 2

Question 1

In QuickBooks Online, which feature automatically matches bank transactions to existing records in the books?

Accepted Answer

Bank Feed / Bank Rules

Answer

Bank Feeds in QuickBooks Online automatically download transactions and Bank Rules auto-categorize and match them to existing records.

Question 2

A company uses a cloud-based accounting system. Which security practice is MOST critical to protect sensitive financial data?

Accepted Answer

Enabling multi-factor authentication (MFA) for all users

Answer

MFA adds a second verification layer beyond a password, significantly reducing the risk of unauthorized access to cloud accounting systems.

Question 3

When importing a CSV file of transactions into accounting software, what must be done FIRST to ensure data integrity?

Accepted Answer

Map CSV columns to the corresponding software fields

Answer

Column mapping ensures each CSV field (date, amount, description) aligns with the correct field in the accounting software before import.

Question 4

In a relational accounting database, what is the primary purpose of a foreign key?

Accepted Answer

To link a record in one table to a record in another table

Answer

A foreign key creates a relationship between two tables, such as linking an invoice record to a customer record using the customer ID.

Question 5

Which accounting software report is BEST used to identify which customers owe money and for how long?

Accepted Answer

Accounts Receivable Aging Report

Answer

The Accounts Receivable Aging Report categorizes outstanding invoices by time buckets (0-30, 31-60, 61-90 days) to show overdue amounts by customer.

(CAT) Certified Accounting Technician Practice Test