Illustration: Harbor Wholesale is a fictional business; numbers are examples. Harbor is a food wholesaler with two warehouses, retailers who pay on 30-day terms, and three consignment agents. This case study follows its setup from the first screen to a balanced opening.
Key takeaways
- Harbor starts from a blank book with the Wholesale / Distribution template, then creates its two locations.
- Accounts Receivable and Accounts Payable are one total each: 45,000,000 and 30,000,000.
- Opening stock is 4 items x 100 units x 200,000 = 80,000,000, posted to the default location.
- Moving 50 units of Item A to the branch is a separate transfer in month one.
- The non-stock lines balance at 245,000,000 on each side.
The business
Harbor sells four items, Item A to Item D, each counted in units. Retailers buy on net 30 terms. Stock sits in the Main Warehouse and the Branch Warehouse.
Step 1: Start blank, with the right template
On the start screen Harbor chose Blank — No Data, because it wanted real figures, not sample data. It picked Wholesale / Distribution as the business template. Sample Data vs Blank Start covers that screen.
Step 2: Create the two locations
Harbor's Main Warehouse (LOK-01) is the default, and Branch Warehouse (LOK-02) holds the branch stock. Create them with the Locations button on Stock List, as in Creating Locations and the Default Location.
Step 3: The non-stock opening lines
Harbor entered these lines on Settings > Initial Setup > Opening Balances, with the opening date set to 1 January:
| Line | Account | Debit | Credit |
|---|---|---|---|
| Cash, Harbor operating bank account | 1-1001 | 200,000,000 | |
| Accounts Receivable, all retailers together | 1-1101 | 45,000,000 | |
| Accounts Payable, all suppliers together | 2-1001 | 30,000,000 | |
| Paid-in Capital | 3-1001 | 215,000,000 | |
| Total | 245,000,000 | 245,000,000 |
Receivables stay one total. Harbor keeps each retailer's balance in its own spreadsheet. The delivery van is not in this table. Harbor posts it by journal, as Opening Balances describes.
Step 4: Opening stock
Under B. Opening Stock per Product, Harbor added one row per item:
| Item | Qty | Unit Cost | Value |
|---|---|---|---|
| Item A | 100 | 200,000 | 20,000,000 |
| Item B | 100 | 200,000 | 20,000,000 |
| Item C | 100 | 200,000 | 20,000,000 |
| Item D | 100 | 200,000 | 20,000,000 |
| Total | 400 | 80,000,000 |
Reyuko posts the stock as one adjustment to Main Warehouse. Assets are now 325,000,000 (cash, receivables and stock). They are matched by 30,000,000 of payables and 295,000,000 of equity: 215,000,000 Paid-in Capital (3-1001) plus 80,000,000 Opening Balance Equity (3-1004).
The stock credit posts to 3-1004, not 3-1001, so 3-1004 shows 80,000,000 after posting. The non-stock lines balance on their own, so they add nothing to 3-1004.
Step 5: Month one, the branch receives stock
In the first week, Harbor moves 50 units of Item A from Main Warehouse to Branch Warehouse. Transfer needs the Advanced level, so check it in Settings > Customization first. A transfer posts at once and creates no journal, so the stock value stays at 80,000,000.
| Item | Main Warehouse (LOK-01) | Branch Warehouse (LOK-02) | Total |
|---|---|---|---|
| Item A | 50 | 50 | 100 |
| Item B | 100 | 0 | 100 |
| Item C | 100 | 0 | 100 |
| Item D | 100 | 0 | 100 |
Step 6: Users
Harbor added eight users, each linked to an Employee contact: one Owner (the first user), one Accountant, two Sales, one Purchase, one Warehouse user, and two drivers on Standard Employee. Reyuko showed each temporary PIN once.
- Go to Settings > Initial Setup and click Open on Opening Balances.
- Set Opening Date to 1 January.
- Enter the Cash, Accounts Receivable, Accounts Payable and Paid-in Capital rows from Step 3.
- Under B. Opening Stock per Product, click Add Stock Row for each item in Step 4.
- Click Save Draft, check the difference, then click Post Opening Balances.
- Go to Settings > Users & Subscription, open Users and click Add User for each person in Step 6.
Check yourself: what is the total stock value after the transfer?
80,000,000. A transfer moves quantities between locations and does not change the value of stock.
Reyuko