Creating bank rules in QuickBooks to separate American Express (AmEx) transactions by cardholder

We’ve had several firms reach out about how to separate transactions for multiple AmEx cardholders when the transactions come into QuickBooks in one AmEx bank feed. Perhaps the best solution is to create bank rules that separate the transactions into different accounts based on the cardholder name contained in the Description/Memo. For example, if the Description/Memo includes the name “John Doe” then the rule puts the transaction into the “AmEx - John Doe” account in the general ledger.

From there, if you need more information from the cardholder to properly categorize the transaction, you can move the transaction at issue into an account “AmEx Uncategorized - John Doe” and sync that account into Uncat and assign that account to John Doe in Client Settings in Uncat. Or, simply leave the transactions at issue in the “AmEx - John Doe” account and categorize all the rest of transactions. That way, the only transactions left in the “AmEx - John Doe” account are transactions where you need more information from the client. Sync that account to Uncat and assign it to the John Doe user in Client Settings.