When you convert Banco AV Villas bank statement PDF to CSV for QuickBooks, you bridge two different worlds: a Colombian bank statement written in Spanish, with pesos, day-first dates, and comma decimals, and QuickBooks Online, which expects clean US-style rows. Banco AV Villas, part of Grupo Aval, issues statements through its virtual branch and mobile app, and those PDFs are fine for reading but useless for importing. A careful conversion handles the language, the date order, and the number format in one pass, so your books stay accurate without retyping every line.
The most expensive mistakes here are silent ones. A date like 04/07/2026 means April 7 in the United States and July 4 in Colombia, and a comma decimal like 1.250,50 means something completely different to a US spreadsheet than it does on the statement. This guide shows how to download the right statement, convert it, normalize those formats, and import it into QuickBooks Online with confidence.
Download your Banco AV Villas statement PDF
Sign in to the AV Villas virtual branch or mobile app, open the account, and look for the statements or extracts section. Select the account and the period, then download the PDF statement rather than copying the on-screen movements. The PDF includes the opening balance, every posted movement, fees, interest, and the closing balance, while the on-screen view often pages through results and drops older rows. If you hold both a savings account and a checking account, download each one separately.
Open the PDF before converting and note three things: the statement currency, the date range, and whether the document covers one account or several. AV Villas statements list movements in Spanish, with terms like consignacion for deposits and retiro for withdrawals. You do not need to translate every word, but you should confirm the opening balance matches the prior statement's closing balance, because a gap there means a missing page or the wrong period. For background on the bank, see our Banco AV Villas bank page.
Convert the PDF and normalize dates and decimals
Upload the PDF to a converter and inspect the CSV row by row. The two fixes that matter most are dates and decimals. Convert every date from DD/MM/YYYY to the MM/DD/YYYY format QuickBooks expects, and convert comma decimals to point decimals, so 1.250,50 becomes 1250.50. Do this in a spreadsheet with find-and-replace done carefully, or with a formula, and then sort the rows by date so the sequence reads correctly.
Also check the description column. Spanish descriptions can run long, and a truncated merchant name makes matching harder later. Keep the full description where possible, and add a short English note in a separate column for your own reference, for example marking payroll, rent, or supplier payments. For the general conversion approach, see our guide on how to convert a bank statement PDF to Excel, which covers the same column checks.
Import the CSV into QuickBooks Online
In QuickBooks Online, open Transactions and Bank transactions, select the account you use for your AV Villas activity, and import the CSV. Map Date, Description, and Amount, and review the preview before confirming. The preview is where format errors show up: dates landing in the wrong month, amounts a hundred times too large because a decimal comma survived, or rows with missing values. Fix these in the CSV and re-import rather than patching dozens of rows inside QuickBooks.
After import, review the suggested matches. QuickBooks matches on payee names and amounts, and Spanish merchant names may not match the English vendor names in your books. Rename or merge vendors where needed, and create bank rules for recurring items like rent, payroll, and utility payments. One careful first month gives you rules that make every later month faster.
Reconcile in pesos and handle exchange rates
Reconcile against the statement closing balance in pesos, not in a converted dollar figure. If your QuickBooks company file runs in US dollars, record the AV Villas account in pesos or use a separate account with an exchange rate applied at month end, and keep the method consistent. Mixing currencies inside one account is the fastest way to create a reconciliation gap that never resolves.
At month end, compare the CSV row count with the PDF movement count, and confirm the closing balance in QuickBooks matches the statement. Small gaps usually trace to a fee or tax line that was dropped in conversion, or a movement dated on the boundary between two periods. Keep the PDF, the CSV, and a note of the exchange rate used together for each month, so your accountant can follow the trail. Our guide on how to reconcile a bank statement walks through the same close in detail.
Frequently asked questions
Why do my AV Villas dates import into the wrong month?
Because Colombian statements use day-first dates and QuickBooks reads them as month-first. Convert all dates to MM/DD/YYYY in the CSV before importing, and check the preview for any date that looks impossible.
How do I fix comma decimals in the CSV?
Replace the thousand separator and the comma decimal so values read as US numbers, for example 1.250,50 becomes 1250.50. Verify a few large amounts by eye after the change, because a missed separator can inflate an amount by a factor of a thousand.
Can QuickBooks handle a Spanish-language statement?
Yes, once it is converted to CSV. QuickBooks reads the rows, not the language. Keep the original Spanish description in the CSV and add your own English note in a separate column if it helps your review.
Should I keep the AV Villas account in pesos or dollars?
Keep it in pesos if the account itself is in pesos, and apply exchange rates only when you report in dollars. Reconciling in the statement currency keeps the closing balance check exact.
Ready to import your AV Villas activity cleanly? Convert the statement, normalize the formats, and import it with the steps above, starting from the ConvertStatement home page. For larger volumes, see pricing for plans that cover more pages per month.