Skip to content
TradingFormsFree trade documents and tools

Blog

Guides on trade documents, Incoterms, customs and running a trading business.

How to Calculate CBM for Shipping (Inches and Centimeters)

CBM is length times width times height in meters, times the number of cartons. We worked a real two carton US shipment in inches and pounds through our calculator: 160 cartons, 12.884 CBM, 455 cubic feet, and why the sea freight bill follows volume here.

5 min read

IIF File Format Explained, With a Real Bank Example

An IIF file is a tab separated text file that QuickBooks Desktop imports. We converted a 12 row bank CSV into one and read it line by line. Ten rows came through, one was skipped on purpose, and one went missing because of a single quote mark.

6 min read

Shipping Marks Example: What to Print on Export Cartons

We marked up a sample order: 48 cartons of ceramic mugs from Vietnam to Long Beach. Here is the full shipping marks example line by line, the totals it has to match on your documents, and how we printed all 48 labels in one PDF.

6 min read

How to Open a QFX File in Excel (Convert QFX to XLSX)

Excel can't read Quicken QFX files. Here is how to convert one to an Excel workbook in under a minute, what each column means, what happened when we merged two overlapping files, and how to add the missing running balance.

4 min read

How to Convert CSV to QBO for QuickBooks Desktop (Free)

QuickBooks Desktop imports bank transactions only as Web Connect (.qbo) files. Here is how to convert a CSV to QBO: which layouts work, how to stop dates swapping, what the Intuit bank ID does, how to avoid duplicates and the import steps.

7 min read

VGM: How to Calculate Verified Gross Mass (Method 1 and 2)

The verified gross mass (VGM) is the cargo, packing and container tare added together. Learn both SOLAS methods with worked numbers, who must sign the VGM declaration, when it is due, and the US road weight check most guides skip.

5 min read

How to Open a QBO File: Convert QBO to CSV or Excel

A QBO file is a QuickBooks Web Connect download that Excel cannot read. Learn what is inside it, how to convert QBO to CSV or Excel for free, merge several months without duplicates, and put the transactions to work in a spreadsheet.

6 min read

How to Scan Receipts into Excel: Free Receipt Scanner Guide

Photograph your receipts, let a free receipt scanner read the store, date, items, tax and total, and download one Excel file with a row per receipt. Tips for faded slips, a simple organizing routine and the US rules on keeping receipts.

6 min read

How to Make a Payslip: Step by Step Guide with a Free Generator

To make a payslip, list the employer and employee details and the pay period, add every earning, subtract every deduction and show the net pay. Here is each step, what a payslip must include, what to do if you are self employed, and a free generator that does the maths.

6 min read

Bank Statement to CSV: 3 Ways to Convert a PDF Statement

How to turn a bank statement into a CSV file you can open in Excel, Google Sheets or accounting software: the bank's export, Excel's PDF import, and a free converter for PDF statements, plus how to check the numbers.

5 min read