SaasAnt Transactions Desktop enables QuickBooks Desktop users to export credit card charges efficiently in bulk. This guide provides clear steps to export your credit card charges seamlessly.

Prerequisites

Ensure you have administrative access to QuickBooks Desktop and a stable internet connection for the initial setup. Verify that your QuickBooks company file is open and updated to the latest version.

Steps for Exporting Credit Card Charges from QuickBooks Desktop

Step 1: Download, Install, and Connect SaasAnt

Before exporting credit card charges, set up the SaasAnt Transactions Desktop application.

• Download: Visit the SaasAnt.com website and download the SaasAnt Transactions Desktop application.

• Install: Run the installer file and follow the prompts to complete installation on your computer.

• Connect: Launch the SaasAnt application, then connect it to your QuickBooks Desktop company file using the on-screen instructions to authorize data access.

Step 2: Configure Export Settings

• Access the Export module in SaasAnt Transactions Desktop after connecting to QuickBooks.

• Select Credit Card Charge as the QuickBooks transaction type to focus on credit card charge data.

Step 3: Set Date Range

Choose the date type with two options: Created/Modified Date or Transaction Date.

• Created/Modified Date refers to when the credit card charge was originally entered into QuickBooks or last edited.

• Transaction Date is the charge date on the transaction.

Select a range using the custom date picker, or pick from quick options like Today, From yesterday, Last 7 days, Last 30 days, etc.

Step 4: Set Export Template

Use the default SaasAnt template for standard credit card charge fields.

To customize, click the “+” icon, select desired fields (for example: credit card account, payee, date, reference number, memo, expense or item details, amounts, class), name the template, and save it for reuse.

Step 5: Apply Filters (Optional)

Filters help you precisely target specific credit card charges, reducing the dataset for faster exports and better focus.

• Account: Select one or more accounts to export charges posted to a specific credit card account or payment account.

• Employee: Filter charges linked to a specific employee when employee names are used on the transaction.

• Vendor: Filter by one or more vendors to export charges for specific payees.

• Reference No (From-To): Enter a starting and ending reference number to export a specific range of credit card charges.

To apply a filter:

Choose the filter on the left, set the value (and range for Reference No), then click Add or Update Filter.

Your applied filters appear under Current Filter Choices.

To remove one filter, select it and click Remove Selected Filter.

To remove everything, click Clear Filters.

Step 6: Adjust Settings

Customize the export output via settings to match your reporting or integration needs.\

• Date Format: Switch between formats like MM/DD/YYYY or DD/MM/YYYY for compatibility with other systems.

• Show Customer/Vendor by Account Number: Display payee IDs instead of names when your file uses account numbers for names.

• Show Transaction Lines: Include detailed expense and item lines for each credit card charge, or export only summary-level data.

• Show Account Numbers: Add numeric account codes alongside account names for easier review and reconciliation.

Toggle settings on or off as needed.

Step 7: Run Search

Click Search to retrieve matching credit card charges based on your criteria. Review the preview before proceeding to export.

Step 8: Review and Download Results

SaasAnt displays credit card charges matching your date range, filters, and settings.

Select your preferred format: Excel for spreadsheets with formulas or CSV for simple data export.

Click Download to export the file to your computer. Verify the downloaded file contains all expected credit card charge data before use.

Step 9: Schedule Recurring Exports (Optional)

SaasAnt offers automated scheduling for regular credit card charge exports without manual intervention.

• Provide a Report Name for easy identification.

• Set Frequency as Daily, Weekly, Monthly, or use a Cron Expression for advanced scheduling.

• Specify the export Time.

• Choose Export Mode: Local folder, FTP or SFTP server, Email delivery, or Database connection.

• Select the destination Folder and File Format (Excel or CSV).

• Click Save to activate the schedule. Monitor scheduled jobs via the SaasAnt dashboard for status and logs.