不想手动操作？使用我们的在线银行对账单转换器，即可将 PDF 对账单转换为 Excel、CSV、QBO 或 OFX 文件。
常见问题
Can I auto-categorize bank transactions in Excel without macros?
Yes. Use an INDEX and MATCH formula with SEARCH to look up keywords in transaction descriptions and return matching categories from a reference table. The formula works in all Excel versions and requires no VBA or macros.
Do QuickBooks bank rules work with uploaded PDF statements?
No. QuickBooks bank rules only apply to transactions imported via connected bank feeds. If you upload a CSV or PDF statement manually, you must categorize those transactions manually or use Excel formulas before import.
How do I handle vendors like Amazon that sell multiple types of products?
Assign Amazon to a catch-all category or flag it as Uncategorized, then review those transactions manually once per month. Alternatively, use separate credit cards for different expense types so the payment method itself acts as the category filter.
What is the fastest way to auto-categorize transactions from scanned bank statements?
Use a converter tool that extracts transactions from scanned PDFs with OCR and applies keyword-based categorization rules during extraction. The output CSV or QBO file arrives with categories already assigned, ready to import into your accounting software.
How many keyword rules do I need to categorize most transactions automatically?
Start with 10-15 keywords for your most frequent vendors. This typically auto-categorizes 60-70% of transactions. Add 2-3 new keywords per month as you encounter new vendors. After three months, you will have 20-25 keywords that handle 80-90% of your monthly transactions.