Most of our services are only accessible after you are logged in. Sign up for a free account by clicking the
Sign Up Free
button and follow the provided instructions. Once completed, click the activation link in your email and you should now be able to log in and start uploading your entries (see instructions below).
2. Uploading Entries and the Beginning Balance:
Our system accepts Excel (.xlsx) files which you can upload once logged in.
Important: Free Trial account can only upload 100 entries in a month.
You can upgrade your account in the profile menu after logging in by taking one of the three available plans starting from USD 89. Each upgrade will last for 30 days and if not extended, your account will be downgraded back to Free Trial plan.
For normal transactions, you only need to have 4 of these columns in your Excel file: 1. 'date' = transaction occurence time (DD/MM/YYYY or YYYY-MM-DD) which will allow you to know exact information on a certain period instantly using our Dynamic Period feature2. 'base_account*' = name that represent groupings of similar transactions or same in characteristics3. 'account*' = the account which affects or got affected by the 'base_account's changes, similar yet opposites of 'base_account'4. 'amount' = the base_account's money-equivalent value, positive means increasing, negative otherwise <-- Important: the amount column always refers only to the base_account, please pay enough attention to the negative or positive sign.
* Only letters, numbers, and spaces are allowed
There is an additional column if you want to write a note to the entry or use the inventory and/or depreciation features:
5. 'note' = useful for writing additional note which will do nothing but help the user remember related things6. 'adjust' = depending on the syntax (see point 4 below), this column will be recognised by Plomia's system to either run the inventory or the depreciation feature
For example, suppose this is your financial position at the beginning of the period when starting to use Plomia.com. Therefore, your entries should be adjusted prior to uploading:
First, you will need to split and equalise your balance sheet accounts:
base_account | account | amount:
- Cash | Accounts Payable | 70,000 <-- the 80,000 remaining 'Cash' will be used for the next calculations
- Cash | Salaries Payable | 15,000 <-- 65,000 'Cash' remains
- Cash | Bank Loan | 65,000 <-- 'Cash' finished, 235,000 'Bank Loan' remains
- Accounts Receivable | Bank Loan | 50,000
- Inventory | Bank Loan | 70,000
- Machinery | Bank Loan | 115,000 <-- 'Bank Loan' finished, 35,000 'Machinery' remains
- Machinery | Retained Earnings | 35,000
- Land/Building | Retained Earnings | 50,000
- Land/Building | Capital | 450,000 <-- all finished and balanced, no remainders
Once ready, you can click the 'upload' button at the top of the page (or in the top-right menu for smaller screens). Your Excel entry should then look like this:
After being uploaded and moved to the correct positions:
3. Asset Depreciations and Prepaids Adjustment:
Adjustment entries are entries with additional 'adjust' column which will trigger our system's special feature.
There are currently 1 (one) supported special entry type, which is asset depreciation and/or prepaid feature.
Important: put the inventory account name and asset name in the 'account' column (NOT 'base_account'). Failure to do so may cause significant error!
The asset depreciation and/or prepaid feature will automatically reduce and convert the value of the specified account over time into depreciation or prepaid adjustment expense.
There are two conditions with different format/syntaxes: purchasing assets and disposing assets.
Important: each unique asset_id can only be disposed once, newer disposal entry will replace/overwrite any previous disposal entry for the same asset_id.
E.g. fully charging the remaining Prepaid Office Rent (e.g., asset_id 228999) in the middle of the usage period:
'date' = 2022-04-01 'base_account' = Cash 'account' = Prepaid Office Rent <-- Important: put the asset name in the 'account' column (NOT 'base_account')! 'amount' = 0 <-- the actual paid or gained (cash) amount to dispose the prepaid expense, may carry profits or losses, usually zero 'adjust' = 228999
E.g. selling the packaging equipment (e.g., asset_id 255999) after 2 months:
'date' = 2022-06-01 'base_account' = Cash 'account' = PackPro 2200RX <-- Important: put the asset name in the 'account' column (NOT 'base_account')! 'amount' = 1200 <-- selling price/disposal value (cash), may carry profits or losses 'adjust' = 255999
4. Editing and Downloading Reports
Limited editing such as changing names and positions can be done directly on the dashboard, however, amount, date, and other major changes must be made by uploading adjustment entries. Click any account you want to edit, you will see this menu below showed up beside it. Click on the icons depending on your needs:
= 'Move', default and special accounts (system accounts) like Asset, Inventory, Retained Earnings, etc. which are automatically created by the system are immovable
= 'Add Sub/Child Account', create a new account inside the current account
= 'Edit Name', this will change all the previous account name in the database into the new value
= 'Show Entries', will show all the entries containing the account name
Download your financial report by clicking 'Download' at the top (or in the top-right menu for smaller screens) and choose
Your last configured date will be used in the PDF report.
Accounts having zero amounts are not showed on the downloaded reports. Download sample PDF report and Excel report.