The video includes the following:
- Demonstration using direct excel import
- Mapping equity accounts
- Building "Financial Reports"
Related Article:
How to account for Sole Trader Equity
Click here for:
Working with "Financial Reports"
Example 1
Start at Financials. Make sure you've connected your accounting system and completed the import to secure the data for the year in question.
If you don't have financial data available via one of the connected cloud accounting platforms you can use the an excel direct import or LodgeiT Smart Excel Utility Tool to easily convert and reports from almost any accounting system including all legacy desktop systems.
The Financials sector will allow you to see your imported and reports.
In the Financials section of LodgeiT, select profit & Loss. The net profit should be exactly the same as the net profit visible in your source accounting system.
In the Financials section of LodgeiT, select balance sheet. Your imported balance sheets should balance.
Note, that this section provides visibility over the account lines imported from the source accounting system. Negative values (-) denote debit & positive values denote credit since this this is a balance sheet aspect view & not a trial balance view.
Note that we have a special equity category account for recording drawings transferred to retained earnings. At the start of each new period, you'll need to post a journal with a debit drawings to and a credit to drawings. If you have capital introduced, you'll need to do the same.
Navigate to Accounts to carry out classification of the imported line items. You have two entry point options.
Use the following, market classification categories for your sole trader.
Example of classification from the financial report extracts shown above. Note where the drawings to line is classified to.
Once you've classified the imported financial statement line items you are ready to generate Special Purpose Financial Reports for your sole trader.
Select Reports and then Custom Reports.
Now choose a template. Currently you have two options.
Name your report and select a financial year.
So long as all your sole trader details are included at Settings -à General & Settings -à Contact Details, you should get the following
Example 2
Opening Balance Equity is an account that's used to automatically capture opening adjustments in 'QuickBooks Online'. i.e. if I start a bank feed on 1 July 2010 and create an opening bank balance of $10 i.e. a debit, 'QuickBooks Online' will automate the credit into the Opening Balance Equity account. The same approach applies if in 'QuickBooks Online', User adds a list of creditors and/or debtors. Essentially, 'QuickBooks Online'uses this account to ensure the system cannot go out of balance. If you see a 'QuickBooks Online' file with a value in this account, it means fixes are required.
A better understanding of Opening to Closing Balance flow (Charlie names it as a roll-forward) can be seen with equity of a sole trader - see following example -
View of equity section of special purpose financials under reports in LodgeiT.
View of balances in Xero Financials section.
Equity line item mappings in Accounts module in LodgeiT. Note how drawings are offset to the retained earnings since the story is that owners drawings are paid from retained earnings and therefore reduce retained earnings. EXACTLY as dividends are paid from retained earnings in a company.
NOTE:
- This has been posted an opening journal to move 2019 drawings to Retained Earnings section since - systems like 'QuickBooks Online' and - Xero doesn't use all these concepts
- Drawings account is perpetual in Xero without moving the prior year values out to retain.
Related article:
How to account for Sole Trader Equity
Other Related Article:
The LodgeiT Approach on Preparing "Financial Reports"
Financial Report - E Signature
Managing "Financial Report" Template