How to Upload Bank Statements and Extract Data Using SmartDocs 360

Overview

SmartDocs 360 extracts transaction data from PDF bank statements and exports it into various formats for easy import into accounting software. This helps you:

• Extract bank statement data quickly, avoiding manual entry.

• Support all Australian banks.

• Export to CSV, Excel or QIF for compatibility with multiple platforms.

Steps:

1. Upload Bank Statements

2. Review and Edit Data

3. Export and Import into Accounting Software

Step 1: Upload Bank Statements

Upload via Documents Screen

Navigate to Documents in SmartDocs 360.
Click Upload Documents

Upload via Email

• Send your bank statements to the designated SmartDocs email.

Processing Time

• Extraction takes up to 2 minutes, with 90% of files processed in under 30 seconds.

Step 2: Review and Edit Data

Once uploaded, click on the uploaded bank statement to review extracted data.

Once selected, the preview screen will display

• The left panel displays the original PDF.

• The right panel shows the extracted transactions.

Additional Features:

Sort by Columns: Click column headers to reorder transactions.
Toggle DR/CR Columns: Switch between Debit and Credit views.
Manually Add Line Items: Click a button to insert new transactions.
Show/Hide Column Filters: Toggle visibility of filtering options.
Adjust Density: Change text size for better readability.

Exporting Data:

• Click  and select a format:

  • CSV (for general use)

  • Excel (for manual adjustments)

  • QIF (for QuickBooks and financial software)

  • QuickBooks CSV (pre-formatted for QuickBooks)

  • Xero

Troubleshooting

• Missing Import Button? Ensure active bank accounts are linked in your software.

• Extraction Issues? Click Feedback to report problems.