We’ve completely rebuilt our bulk importer from the ground up. It is no longer just a file uploader—it’s a universal translator for your financial data.
Why the New AI Importer is a Game-Changer:
No Templates Required: Forget the rigid CSV templates of the past. You can now drop in raw, unstructured CSVs or even PDF bank statements. No more reformatting columns to make your data "fit."
Complete Data Mapping: We’ve expanded beyond just dates and amounts. The AI now transcribes and maps Accounts, Companies, Categories, and Classes directly from your file.
Intelligent AI Categorization: Our AI reads your item descriptions and automatically maps them to the correct project category. It knows "Lumber" belongs in Framing and "Faucets" belong in Plumbing.
Automatic Transaction Grouping: To make reconciliation easy, expenses are grouped by Transaction ID. This ensures your digital records in FlipperForce perfectly match your physical receipts.
4 Ways to Import Your Data
To get the most accurate results, simply choose the source that matches your file:
Retailer Purchase History (Home Depot & Lowe's) : Export your "Detailed Purchase History" from Pro Xtra and drop it in. The AI transcribes every single line item, assigning the vendor, category, and material class for you.
Accounting Software (QuickBooks & Xero) : Export a project report from your accounting software. The AI maps that data into FlipperForce so your project-level tracking stays in sync with your high-level books.
Bank or Credit Card Statements : Upload a monthly statement in PDF or CSV. The AI identifies the vendor, extracts the amount, and suggests the correct budget category.
Miscellaneous Spreadsheets:: Have a custom tracker or a messy Excel file? The AI scans the file and finds the relevant data regardless of your column order or headers.
Setting the AI Up for Success
While our AI is built to handle "messy" data, a little prep goes a long way:
Consistent Naming & Numbers: The AI uses "fuzzy matching" to link your file to your FlipperForce settings. If your file uses Company names or Account numbers (like the last 4 digits) that closely match what you have in FlipperForce, the AI can map them instantly. If the data is too vague or doesn't match, the AI will leave the field blank for you to review in the next step.
Eliminate Confusing Data: Some exports (like Home Depot) provide multiple columns for "Amount," "Tax," and "Total." Deleting these extra columns before you upload prevents the AI from getting "distracted" and ensures it pulls the correct final totals every time.
Verify with the Preview Window
Precision is critical for your lenders and partners. Our new Preview Window lets you verify results before they hit your books.
Using a stacked row layout, we display the Imported Data directly on top of the Original Data from your file. This makes it incredibly easy to spot-check for accuracy and make quick edits. Once verified, click Confirm and your expenses are imported and organized instantly.
Thumbs up to select your best comps, thumbs down to push the bad ones to the bottom — keeping your list clean and your Comps Report focused on the properties that actually matter.
Our new Public API update allows developers and custom AI tools to securely connect to the FlipperForce Expense Tracker to automate data entry, feed custom dashboards, and sync project financial records directly from external business apps.
Tax & Insurance column added to Companies & Contacts, giving you instant visibility into W-9 status and color-coded Workers Comp and General Liability expiration dates for every contractor in your workspace at a glance.
Our newly revamped Property Data and Owner Data pages feature a clean, highly legible layout along with a brand-new, completely editable Seller Motivation Matrix to help you seamlessly track and document critical lead details and distress signals.
Manage your entire project from one centralized "Command Center" that combines settings, status tracking, and critical tools into a single, high-clarity view.
You can now calculate your Desired Profit based on a % of Total Project Costs in the Flip Analyzer and save it as a global default in your settings for faster, ROI-driven deal analysis.
.png)
.avif)
