How-to guides

How-to guides: bookkeeping from your bank statements

Pick the job you have. Each guide shows the steps, says what Pennyrow checks and what it leaves to you, and uses a made-up worked example. Your statements are read inside your browser and never uploaded.

• How to catch up on a year of bookkeeping yourself
  Behind on bookkeeping? Gather your statements, find missing months and duplicates, match transfers, sort expenses, then export. Nothing is uploaded.
• Export a year of Apple Card transactions to one spreadsheet
  Export a year of Apple Card transactions in one file with a start and end date, then open it in Excel or Sheets. Pennyrow reads the file on your device.
• Convert an OFX or QFX file to CSV or Excel
  Convert an OFX or QFX bank download to CSV or Excel on your device. Pennyrow reads the file in your browser and lists duplicates and transfers. No upload.
• Schedule C expense categories for your bank and card transactions
  Sort bank and card transactions into suggested Schedule C (Form 1040) lines you confirm, then total the year as a profit and loss summary. Runs in your browser.
• How to find the payees you may need to send a 1099-NEC, from your bank statements
  Find the payees you may need to send a 1099-NEC. Pennyrow totals business payments by payee from your bank statements and lists those over the IRS amount.
• How to get a bank statement PDF into Google Sheets
  Get a bank statement PDF into Google Sheets: convert it to CSV or Excel on your device, then import the file. Pennyrow never uploads your statement.

Looking for your bank?

The guides by bank say where each bank keeps its statements, how far back they go and which downloads it offers.