Digital Invoice Prep for Small Business Loan Applications
This guide walks you through preparing digital invoices for a small business loan application. You’ll learn how to organize, format, and present your invoices so lenders can quickly verify your revenue and cash flow. First, gather your accounting software or invoice files, a PDF viewer, and a spreadsheet program if you want to create a summary.
What You’ll Need
- Access to your invoicing software (e.g., QuickBooks, Xero, FreshBooks) or a folder of invoice PDFs
- A PDF editor or scanner app (for combining and renaming files)
- A spreadsheet program (Excel, Google Sheets) for creating a summary
- A secure cloud storage or file-sharing service for sending large files
Step-by-Step
- Determine the required time period. Most lenders ask for the last 3 to 6 months of invoices, but some may want a full year. Check your loan application instructions or ask your lender directly.
- Export your invoices from your accounting software. In most programs, go to the Sales or Invoices section, select the date range, and choose “Export� or “Download.� Choose PDF format for individual invoices, or CSV if you need a list. If you use paper invoices, scan them at 300 DPI to PDF.
- Organize the files by date. Create a folder for each month (e.g., “2024-01 January�). Inside each, place the invoices in chronological order. Rename each file consistently, such as “2024-01-15_Invoice_1023.pdf� (date, invoice number).
- Combine all invoices into a single PDF. Use a PDF merger tool (Adobe Acrobat, Smallpdf, or your operating system’s print-to-PDF feature) to combine all monthly folders into one master PDF. Ensure the pages are in chronological order.
- Review each invoice for completeness. Lenders want to see: your business name and contact info, the client’s name, invoice date, invoice number, itemized services/products, amounts, total, and payment status (paid, outstanding, overdue). If any invoice is missing these, correct it or add a note.
- Mark paid vs. unpaid clearly. If your software doesn’t show payment status on the invoice, add a stamp or text overlay: “PAID� or “OUTSTANDING.� This helps lenders assess your receivables.
- Create a summary spreadsheet. In Excel or Google Sheets, make columns: Invoice Number, Date, Client, Amount, Status (Paid/Unpaid). List every invoice, then add a total row for each month and a grand total. This summary acts as a table of contents.
- Cross-check the summary against the PDF. Go through the combined PDF and verify that every invoice in the summary appears, and that the totals match. Fix any discrepancies.
- Export the summary as a PDF. Save the spreadsheet as a PDF so it can be included with the invoice package. Keep the original spreadsheet for your records.
- Compile the final package. Create a single PDF that includes: 1) the summary page, 2) the combined invoices in order. Alternatively, you can submit the summary PDF and the invoices PDF as separate files, but clearly label them.
- Add a cover letter (optional but helpful). Write a brief note explaining the time period covered, the total revenue, and any notes about large invoices or seasonal fluctuations. This shows professionalism.
- Upload or send the files. If the lender has a portal, upload the PDF(s) there. If emailing, compress the PDF if it’s over 10 MB, and use a secure file transfer service like Dropbox or Google Drive with a shareable link.
Common Mistakes
- Submitting unorganized files: Sending a folder of 50 individual PDFs without a summary makes it hard for the underwriter to review.
- Including invoices outside the requested period: Stick exactly to the date range asked for. Extra invoices can confuse the analysis.
- Omitting unpaid invoices: Lenders want to see your accounts receivable. Hiding unpaid invoices looks like you’re trying to inflate revenue.
- Mixing currencies or formats: If you have invoices in different currencies, convert them to the lender’s currency using the exchange rate on the invoice date, and note that.
- Not checking for duplicates: Duplicate invoices (e.g., a corrected invoice and the original) can make your revenue look higher than it is.
- Submitting blurry scans: Low-quality scans are hard to read and may be rejected. Always scan at 300 DPI.
Tips
- Use your accounting software’s reporting: Most programs can generate a “Sales by Customer� or “Invoice List� report that you can export as a PDF. This can serve as your summary.
- Highlight key figures: On the summary, bold the monthly totals and the grand total so they stand out.
- Keep a clean copy: Remove any internal notes or memos that aren’t relevant to the loan application.
- Be consistent with naming: Use the same file naming convention throughout, so it’s easy to locate a specific invoice if the lender asks.
- Check with your lender for specific requirements: Some lenders want invoices only for certain clients or projects. Ask in advance.
Troubleshooting
If your invoices are in paper form and you don’t have a scanner: Use a smartphone scanning app (like Adobe Scan or CamScanner) to capture clear images, then combine them into a PDF.
If the combined PDF is too large to email: Compress the PDF using a tool like Smallpdf or Adobe Acrobat’s “Reduce File Size� feature. If it’s still too big, use a cloud storage link.
If you’re missing invoices for the period: Contact your clients for copies, or check your accounting system’s audit log. If you can’t find them, provide a written explanation to the lender.
If your accounting software doesn’t export PDFs: Print each invoice to PDF using your browser’s print dialog (choose “Save as PDF� as the printer).
If the lender rejects your format: Ask for their specific template or requirements. Some lenders have a preferred format for the summary.
Frequently Asked Questions
Q: How far back do lenders typically look at invoices?
A: Usually 3 to 6 months, but some may ask for 12 months, especially for larger loans or seasonal businesses.
Q: Should I include invoices that are unpaid?
A: Yes, include all invoices for the period, clearly marking them as paid or unpaid. Unpaid invoices show your accounts receivable, which is part of your cash flow picture.
Q: Can I redact client names?
A: No, lenders need to see client names to verify the invoices are real and to assess customer concentration. Redacting them will raise red flags.
Q: What if I use a cash-basis accounting system?
A: Lenders understand this. Just provide the invoices as they are; the lender will adjust for cash vs. accrual if needed.
Q: Do I need to have invoices notarized?
A: No, notarization is not required for invoices. Lenders may ask for bank statements to corroborate the amounts.
Q: What if my invoices are in a foreign currency?
A: Convert them to the lender’s currency using the exchange rate on each invoice date, and note the conversion method in your summary.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.