Using Pennyweight in Latin America

Pennyweight links banks in the US only, so accounts in Mexico, Brazil and the rest of Latin America use statement import. You add each account by hand in its own currency, and your AI reads your statements into it, one month at a time. New to this? Start with use Pennyweight without a bank link.

What banks in the region give you

What's on offer depends on your bank. Two examples from the banks' own pages:

• BBVA México. Statements come as PDFs and carry fiscal elements: a folio fiscal, a certificate, a digital seal and the SAT's seal. You can get credit card and checking statements up to 10 years old. If you ask for a statement by email, you set a password that protects the file.
• Nubank (Nu Empresas, Brazil). The business account's Exportar Extrato option sends the statement as OFX, PDF and CSV.

Pennyweight has no reader for PDFs, OFX files or fiscal XML files, and it saves the transactions, not the file. Your AI opens the file in your chat and sends the transactions to Pennyweight as rows. See import a PDF or screenshot statement and OFX, QFX and QBO files.

How to do it

1. Ask your AI to add a manual account with its currency, such as MXN, BRL or COP. Give the balance at the start of your oldest statement as its opening balance. A new manual account needs one before its first import saves.
2. Share the oldest statement first and name the account.
3. Check the preview. The account's balance after the import should equal the statement's closing balance.
4. Say yes. Your AI saves the rows and reports how many went in and the account's new balance.
5. Repeat with the next month's statement. Later imports don't need an opening balance: leave it out and they build on the one already set.

What you'll see

For the first prompt, your AI adds Cuenta Pesos in MXN, reads the statement and shows a preview: how many rows are new and the account's balance after the import. For this statement, that balance equals the closing balance printed on it. After you confirm, your AI reports how many rows were saved to Cuenta Pesos.

With several statements, ask your AI to import them one at a time, oldest first, and to compare the account's balance with each statement's closing balance before the next. For a checklist you can repeat each month, see a monthly statement routine.

Good to know

• Pesos stay pesos. Rows without their own currency take the account's currency. Each amount is stored in its own currency and is never converted, so an MXN account and a USD account each keep their own balance. Totals that combine your ledgers, such as your net worth, keep the figures per currency and add one figure in your display currency. See choose the currency for totals across ledgers and accounts and totals in more than one currency.
• Protected PDFs. Whether your AI can open a password-protected PDF depends on your AI app. If it can't, open the file yourself and save a copy without the password.
• CSV downloads. Pennyweight can also read a CSV file directly. It works out decimal commas such as 1.234,56 on its own. It converts dates written YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY, DD.MM.YYYY or YYYYMMDD once your AI names which order the file uses. It never guesses the order, and a date in any other form blocks the whole file. For those, let your AI read the file. See bank CSVs with decimal commas, semicolons and day-first dates.
• A balance that doesn't match. Check the opening balance and each row's direction. Your AI can undo the whole import and run it again. See undo an import. See balance looks wrong after an import.