A balance sheet is a snapshot of your company's financial standing at a given point in time. It includes accounts from the Assets, Liabilities and Equity groups. Dealerlogic enables you to view the Balance Sheet as at the time you run the report or for a previous month end.
The balance sheet shows your company's financial position, what it owns (assets) and what it owes (liabilities and equity). The bottom line of a balance sheet must always balance (that’s why it’s called a Balance Sheet).
•Select the required month from the ‘As at’ field provided by using the Up/Down buttons, or using the Right mouse click select from one of the options provided: (Back 12 months etc).
•Click the Rebuild button to recalculate the balance Sheet as at the selected month end.
•To query an account displayed, highlight it within the report and use the Right mouse click to select “Account Inquiry”. The General Ledger Account Inquiry screen will open with that account selected, together with the same date range as set in the Balance Sheet report.
•Optionally all accounts can be displayed, by default only those accounts with balances will print.
The Balance Sheet can be exported directly to a file format called “.csv” which is a type of text file commonly used for spreadsheet files. The resulting .csv file when opened in Excel is correctly formatted, with headers & footers etc removed.Select the required point in time for your Balance Sheet using the procedure described above. When emailing the Balance Sheet, it will be converted to a pdf format. •To export to excel, select the ‘combo arrow’ located next to the Print button as illustrated and select the File (CSV) option. •Name the resulting file appropriately and save the file in your desired location. •The file can be run directly once located in Windows Explorer – it will open Excel for you – or open Excel first then use the Open button to locate and open the required file. Note that the File Open window in Excel will by default look for files with an “.xls” extension. To locate this file, change the Files of Type selection to read All Files, or Text Files. •To email the Balance Sheet, select the 'combo arrow' located next to the Print button as illustrated and select the Email option. •A new email message will be opened in your default mail program for you to compose with the Balance Sheet attached as a pdf. Note that you can email your Balance Sheet in .csv format so that the recipient can view in Excel. Simply attach the .csv file to an email message. |