Step-by-Step Guide
Follow these steps to create a new Expenses Table in the system:
Navigate to the Data Table Section on the side bar menu.
Click the ➕ icon to add a new table.
A modal will appear. From the dropdown menu, choose Expenses Table as the table type you want to create.
After selecting the Expenses Table, click the Create Table button. Your new Expenses Table will appear in the navigation bar for quick access.
If you’ve already created all the available tables, the dropdown will display the message: “No available tables.”
Understanding the Columns in Your Expenses Table
The Expenses Table includes the following columns to help you effectively track and manage your business’s immediate expenses. Here's what each column means:
Column | What It Shows |
Date | The date the expense was recorded. |
Title | A brief description or name of the expense (e.g., “Travel to Lagos”). |
Amount | The cost of the individual transaction. |
Total Amount | The total cost of the expense, including any taxes or additional charges. |
Vendor | The supplier or provider the expense was paid to. |
Account | The account from which the payment was made. |
Tax | Any tax amount that is applied to the transaction. |
Discount | Any discount that was applied to the transaction. |
Shipping Fee | Any shipping or delivery costs associated with the expense. |
Paid Through | The payment method used (e.g., bank account or cash). |
Prepaid | Indicates if the expense is a prepaid cost (Yes or No). |
Prepaid Months | The number of months the prepaid amount covers (useful for rent, subscriptions). |
Prepaid Account | The specific account used to track prepaid expenses. |
Withholding Tax | Any withholding tax deducted during the transaction. |
Evidence File | Upload or view related files like receipts or invoices. |
Exchange Rate | Shows the rate applied if the expense was recorded in a foreign currency. |
Customize Table View
You can control how many expense entries appear in your table:
Scroll to the bottom of the Expenses Table.
Use the pagination control to select how many rows to display per page (e.g., 10, 20, 30, etc.).