Skip to main content
Blog/Tips & Tutorials
💡

Tips & Tutorials

Practical tips for budgeting, expense tracking, and getting the most from your bank data.

📊

Convert a PDF Form to Excel: Fillable, Flattened, Scanned

How to convert PDF form data to Excel: merge many filled forms into one sheet, script it free with pypdf, and handle flattened or scanned forms.

6 min readOct 27, 2026
💡

Auto Generate PDF from Google Sheets with Apps Script

Create a PDF from Google Sheets by hand with print settings, or automatically with a short Apps Script that saves it to Drive and emails it every month.

6 min readOct 27, 2026
📊

Monthly Budget Template in Numbers: Build and Fill It

Set up a monthly budget in Apple Numbers on Mac, iPhone or iPad: pick or build a template, import your bank CSV and calculate actuals with SUMIFS.

6 min readOct 27, 2026
💡

Financial Planning Excel Sheet: Free Build With Formulas

Build a free financial planning sheet in Excel: net worth, savings goals with PMT and FV, debt payoff with NPER and an emergency fund line, with worked numbers.

7 min readOct 27, 2026
📊

Power BI: Combine Multiple CSV Files From a Folder

Combine a folder of monthly bank statement CSVs in Power BI with the Folder connector: fix headers and types once, keep the file name, refresh monthly.

6 min readOct 27, 2026
💡

How Venmo Transactions Show Up on Your Bank Statement

How Venmo payments, top-ups and cash-outs appear on your bank statement, whether it shows who you paid, what Visa Direct means, and how to match each line.

5 min readOct 26, 2026
💡

Unknown PayPal Charge on Your Bank Statement: What It Is

How to identify an unknown PayPal charge on your bank statement, what PayPal Pte Ltd means, and why a charge shows in one place but not the other.

5 min readOct 26, 2026
📊

Smallpdf to Excel: Steps, Free Limits and Your File

How to turn a PDF into Excel with Smallpdf, what the free tier and Pro cover, how long Smallpdf keeps your upload, and when its rows need cleanup.

6 min readOct 26, 2026
📊

Nitro PDF to Excel Converter: Desktop and Online Steps

How to convert PDF to Excel with Nitro PDF Pro on Windows or Mac and with Nitro's free online converter, plus OCR for scans and the cleanup to expect.

6 min readOct 26, 2026
💡

Negative Numbers in Parentheses in Excel (and Fixing Text)

Show negative numbers in parentheses in Excel with a custom format, and turn statement amounts like (1,234.56) or 1,234.56 CR into real numbers.

6 min readOct 26, 2026
💡

Monthly Expenses Spreadsheet in Excel From Real Spending

Build a monthly expenses spreadsheet in Excel from bank and card statement rows: columns, categories, a month-by-category pivot and an update routine.

6 min readOct 26, 2026
📊

Investintech PDF to Excel: Able2Extract and the Free Tool

How Investintech's free online PDF to Excel converter compares with Able2Extract Professional, and how to use its custom table selection step by step.

6 min readOct 26, 2026
📊

Import PDF to Google Sheets: 4 Routes That Work

Google Sheets can't open a PDF. Here is how to get its table or data into proper columns: Drive's Docs OCR, Split text to columns, the via-Excel route.

6 min readOct 26, 2026
📊

How to Turn a PDF into Excel: 5 Methods Compared

Turn any PDF into an Excel spreadsheet: Excel's Get Data, Acrobat, the Word round-trip, Google Docs or a converter, matched to your PDF type, plus checks.

6 min readOct 26, 2026
📊

How to Import PDF into Excel with Get Data From PDF

Import a PDF into Excel with Data > Get Data > From PDF: which versions have it, picking tables in Navigator, combining pages, and fixing the result.

7 min readOct 26, 2026
💡

How to Import Bank Statements Into Excel (CSV and PDF)

Import a bank CSV or PDF statement into Excel with Data > From Text/CSV, then fix swapped dates, debit and credit signs, leading zeros and text numbers.

6 min readOct 26, 2026
🏦

How to Get Old Bank Statements Your App Doesn't Show

How to get old bank statements past your online banking limit: archive pages, ordering copies, phone and branch requests, fees and how far back banks go.

6 min readOct 26, 2026
💡

How to Export a Bank Statement to Excel From Online Banking

Most banks let you download transactions as CSV, and some as Excel, QFX or QBO. Learn where the export lives, how far back it goes, and when to use the PDF.

6 min readOct 26, 2026
🏦

Get a Current Bank Statement: What Counts and How

What a "current bank statement" means to a landlord, lender or visa office, and how to get the latest one, or a mid-cycle copy, online or at a branch.

6 min readOct 26, 2026
📊

Foxit Convert PDF to Excel: Whole File or One Table

Convert a PDF to Excel in Foxit PDF Editor: the whole-document export, exporting a selected table, worksheet and number settings, OCR for scans, and fixes.

6 min readOct 26, 2026
📊

Expense Tracker in Google Sheets Fed by Bank Statements

Set up an expense tracker in Google Sheets from your bank statement data: CSV import, category dropdowns, a QUERY monthly summary and a spending chart.

5 min readOct 26, 2026
💡

Copy PDF Table to Excel: Fix the One-Column Paste

Copied a PDF table and it pasted into one Excel column? Fix it with Text to Columns, Paste Special as text or Flash Fill, and know when to import instead.

6 min readOct 26, 2026
💡

Convert PDF to Excel Without Losing Formatting: Fixes

Why PDF to Excel conversions shift columns, merge cells, store numbers as text and break dates, with a symptom table and the Excel fix for each one.

6 min readOct 26, 2026
📊

Convert PDF to Excel on Mac: 6 Methods That Work

Excel for Mac cannot import PDFs. Compare Preview copy and paste, Data from Picture, Numbers, Acrobat, Google Sheets and online converters, plus CSV output.

6 min readOct 26, 2026

Ready to convert your bank statement?

Free to preview. No bank login. Results in about a minute.

Convert a statement