FANDOM


Introduction

The Accounting module is a set of processes that are required to provide company financial information to users. It also provides and analysis support to the business.

Accounting

Accounts

Under this accounts setting, user will able to setup and view the Chart of Account, Account list, Journals and Ledgers in their Swan’s account.

Chart of Account

A Chart of Accounts (COA) is a list of accounts used by an organization. It defines each class of items in which monetary (or equivalent) transactions are recorded. A COA is used as a financial organization tool and serves as a foundation for a company's financial record keeping system.

  1. This function allows Finance Admin to view the company Chart of Accounts and make quick additions via the Quick Add Account shortcut.
  2. Before creating the company Opening Balance, Finance Admin has to ensure that the Chart of account follows the company list of accounts. 
  3. The system provides eight types of Chart of Account templates that users can choose from; Default (a standard Chart of account), Open List (an open Chart of account without Header or Sub Header) and Segmented (a Chart of account which has been segmented with Header, Sub-header and Sub-total).
  4. Quick Add section on Chart of Accounts page allows users to quickly add a new account to the list. 
Coa
List of coa



Account Setup

Accounts provide a means for grouping transactions. When you setup your company account in the system, you will select a default accounts list to start with. This list may already have the accounts you need. If not, you can change the list to suit your needs.

  1. Move your mouse to Accounting >>click on Account List
  2. Account Numbers – Each account is identified using a unique six-digit number. The first digit indicates the account’s classification while the remaining five digits determine its location within the classification. The lower the number, the higher up in the list it appears.
  3. Account Structure – Your accounts list consist of few structure such as Header, Details
  4. Accounts (Sub-Account or Group Account). This structure helps you organize your account list. The following table explains in details of structure available in the system, with reference to the figure below.
Coa class
Coa class decript


Account Classification and Types

The accounts list groups accounts into five classifications; Asset, Liability, Equity, Revenue and Expenses. Within each account classification, there is at least one account type

Asset
Liability

Journals

This function provides Finance Department with a tool to view and make Journals entries. 


View Journals

  • Move your mouse to Accounting >> click on Journals
  • Select the Journals category to view. Leave it blank to see every category.
Select journal
  • Enter the date range of the transaction you are interested in.
  • Click View button.
  • A larger date range and all category selection may yield many records. The system will require time to process.
View journal


New Journal Entry

Add journal
  1. Click New Journals Entry button
  2. A Journals number is auto-generated for you. Key in an alternate number if necessary
  3. Check the This is an auditor edited Journals entry if it is done by auditor
  4. Select a Date for the Journals entry
  5. Project and Department and are not applicable to Swan
  6. Select an account for both debit and credit entries from Account No. dropdown list
  7. Key in respective remarks
  8. Key in either Debit or Credit value for each account
  9. Click Add Line to add additional lines for the Journals entry
  10. The system auto calculated your accounts and ensure the accurate balances
  11. The Journals entry follows standard Accounting principles. Users must ensure the Debits and Credits are balance, though the system will prompt users if it is not balance
  • Auditor Edited Journals Entries are commonly created to make adjustments after closing the accounting books for a period. Since the temporary accounts have already been zeroes out, the system will make necessary adjustments for Auditor Journals Entries. This will ensure the financial statements are accurately reflected


New Tax Journals Entry

Tax journal entry
  1. Click New Tax Journals Entry button
  2. Choose GST Transaction Type: Purchase (Input Tax) or Sales (Output Tax). Tick Tax Inclusive box if the Journals created is tax inclusive value
  3. A Journals Number is auto-generated for you. Key in an alternate number if necessary.
  4. Select a Date for the Journals entry
  5. Project and Department and are not applicable to Swan
  6. Select an Account for both debit and Credit entries from Account No. dropdown list
  7. Key in respective remarks
  8. Key in either Debit or Credit value for each account.
  9. Select Tax code
  10. Click Add Line to add additional lines for the Journals entry
  11. The system auto calculates your accounts and ensures the accurate balances
  12. The Journals entry follows standard Accounting principles. Users must ensure the debits and credits are balance, though the system will prompt users if it is not balance


Edit General Journal

  • Users will be able to edit General Journals via Accounting >> Journals >> select the transactions date >> click view. Choose the Edit icon (a pencil-shaped icon) to edit the selected Journals
  • Most fields are editable such as Date, Accounts that were chosen and its amount. The only field that is not allowed to be edited is the Journals Number
  • This action is audited as an ‘Edit Journals action’ with a Journals Number reference
  • GST Tax Codes CANNOT be changed via this process, though the user is able to edit the tax amount and its linked accounts. The system will not proceed if the Journals is not balanced. The system will NOT perform logic tests if the user changes tax amounts and totals to a value more or less than 6% of the actual transaction value
  • Even if the user changes the tax linked accounts, the tax code linked to the transaction will stay the same.
Example: Users choose the tax code of ‘SR’ (linked account is GST Output) for the transaction and would like to change it to another tax linked account; GST Input via edit Journals feature. Even though the linked account has been changed to GST Input, the tax code for this transaction will still remain as ‘SR’. The GST reports will not show the changes of the linked account and the transaction WILL NOT appear on the reports due to the changes. However, the amount will still be calculated in the balance sheet. Therefore for tax Journals, it is NOT ADVISABLE to edit tax transactions directly from this interface
  • If the user made a mistake in selecting a Tax Code, it is recommended to remove the Journals and do another Tax Journals Entry
Important:

Please be advised that the user should NOT USE this feature without having a PROPER DOCUMENTATION TRAIL as it may affect the accuracy of their GAF and GST Report.

Export Journals

This function allows you to export your journal to excel file

To export the journal entries, you will have to go to Accounting >> View Journals

You can choose to either export all your journals within the selected period or you can filter the journals before exporting them out to excel.

ExportJournal 1

The filter includes:

  • Category such as sales, purchases, general journals, expenses or receivables
  • Search via keywords to select specifi journal entries, the keywords can be from journal number to remarks
  • The transaction date/period
  • Optionally you can choose to search by journal creation date or showed the transactions tax codes

Once you have make your selection, click the "Export Journal" button. The file will be saved as .CSV and can be view via excel.

ExportJournal 3

The journals that were exported will be the same as the one you viewed in the system

ExportJournal 2

Ledger

This function allows Finance department to access to general ledger which holds account information that is needed to prepare financial statements. 

General ledger
 
  • Move your mouse to Accounting >> click on Ledgers 
  • User able to select a particular Account Class or Account Name to view that specific account’s ledger with Beginning Balance, Net Activity and Ending Balance. 
  • Enter the transaction date and click View button 

Banking

Banking features record your bank and cash transactions and keep on top of your finances. You can record the money that goes in and out of bank accounts and credit card accounts whilst managing money that you deposit in a batch, such as customer payments made by Cash, Cheque or Credit Card or record cash payments and purchases. You can also reconcile transactions shown on your bank statement with the information you have recorded in the system to keep your records up-to-date.

Banking

Manage Banks (Add new bank account)

Adding bank is essential as it link your bank account to your company’s Accounting Books. By choosing the bank account in any transaction, the system will automatically add or subtract the figure from the accounting books.

Add bank
  1. Move your mouse to Accounting >> Banking >> Manage Banks
  2. Click Add New Bank button
  3. Key in the bank Account Name, Account Number, description, and details
  4. Select a Link Account Receivable account where any payment received by this bank will be debited.
  5. Select a Link Account Payable account where any payment paid from this bank will be credited.
  6. Key in the bank addresses details for record purposes.
Important For foreign bank account, the linked account chosen MUST HAVE the SAME CURRENCY as the bank. The account’s currency can be determined on the account details in Setup >> Chart of Account << Click on account number

Bank Reconciliation

This function allows Finance Admin to perform reconciliation activities against banks statements. 

Reconcile acct

To reconcile accounts, move your mouse to Accounting >> click on Bank Reconciliation

  1. Select the bank account you wish to reconcile.
  2. Enter the bank statement balance and remark for reference.
  3. Select the bank statement date. The system will auto-calculate the difference between the bank statement and the selected bank account balance. 
  4. A list of unclear transactions will be presented. Select any or all transactions of which you wish to reconcile against the bank account. You may also enter any income or expenditure adjustment such as bank interest.
  5. Select income tab.
  6. Select appropriate credit account from the dropdown list.
  7. Enter description and amount.
  8. Select Expense tab and appropriate debit account from the dropdown list. Enter a description for this action.
  9. Enter the amount. 
  10. In certain cases such as during opening balances, there may exist unrecorded transactions such as unclaimed checks or un-deposited payments from previous periods. In order to reconcile these transactions, you will need to enter the information in the Unrecorded Transactions Section. The system will bring forward the transactions onto the next reconciliation process.
  11. User can save a reconciliation work with multiple bank statement pages if more time is required to perform reconciliations.
  12. Saved reconciliation report can be recalled by clicking on the "Recall" button on the top right of the Reconciliation view.
  13. The system provides reconciliation history which allows Finance Admin to view or reverse the reconciliation. To reverse the account reconciliation at certain period, you will have to reverse the latest reconciliation.


Reconciliation History

This feature provides Finance department a reconciliation history report for the company. The system allows Finance admin to view or reverse the reconciliation.

Recon history 1
Tips

In order for you to regenerate the reconcile account, click Undo button to delete current Reconciliation History record

Credit Card Linked Accounts

The system provides user with default Credit Card linked accounts setup for your Swan account. However, user may still change this setup according to own preferences.

Cc linked acct


Credit card settlement

Credit card settlement feature allow you to reconcile your credit card statement received from bank into Swan.

Credit card settlement will deduct Credit Card Commission and Input Tax from the Credit Card Receivable Account. It will then create bank settlement from the respective Credit Card Receivables account. To access this page, mouse over to Accounting>> Banking >> click on Credit Card Settlement.

Steps for credit card settlements are:

  1. Mouse over to Accounting >> Banking >> click on Credit Card Settlement
  2. Select the Credit Card type you are recording
  3. Select Date Range
  4. Select Bank Account of which the amount of settlement was bank into
  5. Click Load Data
Creditcardsettlement 1
CreditCardSettlement 2

NOTE: The system WILL NOT auto-calculate your commission and input tax on commission. The commission and input tax on commission amount will follow the amount entered.

Payment

Another process that you will need to perform from time to time is making payments and receiving payments. Examples of such transactions include recording utility bills, staff salaries and other ad-hoc or miscellaneous payments.

Swan has built specific features for both of these transactions to simplify this process.

Make A Payment

The expenses function is use for miscellaneous payment to customer or vendor.

It is advisable that you create a contact record for the entity that you are about to make payment to. Follow the instructions on the Contacts and Item List section for instructions on how to create a new contact record.

Recording a payment and selecting a Tax code will result in an INPUT TAX movement in your GST submission.

Move your mouse to Accounting >> Banking >> click on Make A Payment

Pay expense
  1. Select Payee from the dropdown list and choose account of which the payment will be made from.
  2. Check the Update Payee Balance if this payment will affect vendor’s balance. It is advisable to check this only when required as the systems will automatically handles balances based on keyed-in transactions.
  3. Enter payment details and select an account of which the payment will be debited to.
  4. Select project/department if required
  5. Enter details if necessary and the amount to be paid.
  6. Once the payment is posted, the system will auto-generate payment voucher. 


Receive A Payment

The receive payment function is use for miscellaneous payment from customer or vendor. 

Receiving payments and selecting a Tax code will result in an OUTPUT TAX movement in your GST Submission.

Move your mouse to Accounting >> Banking >> click on Receive A Payment

Receive payment
  1. Select Payor from the dropdown list
  2. Choose Account of which the payment will be debited to
  3. Enter Payment Date
  4. Select a Misc Account of which the payment will be credited from
  5. Enter Amount to be received
  6. Click Add Line to add new line entry if you have more than one Misc Account to credit from
  7. Click Process to proceed with receive payment. 
  8. Payment receipt will auto-generate by the system in Receipt Listing
  9. The system allows receiving payment for future dates. This is to ensure accurate record. 

Import Journals

Our import Journals feature allows you to key in your transaction Journals offline in an excel worksheet and upload your work to the system in general Journals format. 


Journal Upload Template

To download the user guide and excel template, you may click button as per shown below:

Import journal
You can import your Journals from a Microsoft Excel Worksheet (.xlsx) file. The file should contain columns with its specific format for
List of impot journal


Upload Journal

There is no limit on number of rows in a file. See a sample of how to format your file for importing. Mouse over to Accounting >> Uploads Transactions >> Upload Journal. Then select your exported Journals file and click "Upload" 

Import journal
Journal excel
Notes:
  1. Group your Journals entry by JOURNALS GRP number. 
  2. Separate each group entry by having a blank row. 
  3. DATE is in string format. It takes the first 3-string characters of the month and ‘/’ or ‘–’ as separator a. Month: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec b. Example: 01/Jan/2015 or 01-Jan-2015 *Date will be set to current date if the date format criteria is not met.
  4. ACCOUNT CODE as per account list setup. If your Journals contain an old account code, please convert it first to match the new account code set up in the system
  5. Enter Journals details in DETAILS column 
  6. Enter debit and credit amounts in their respective DEBIT & CREDIT columns 
  7. Enter TAX CODE as per recommended Tax Codes for Goods & Services Tax prepared by Royal Malaysian Customs Department (pre-loaded in the system). Example: SR, TX, etc.
  8. Setup all the projects in the system and tag them accordingly by project code or project name under PROJECT

Manage Transactions

This chapter explains how to manage your transactions. This includes transactions that have been posted, payment that had been received or paid.

Managing transactions feature is a corrective measure available in the system to ensure the transactions recorded are accurate. Transactions are created when you recorded entries such as Sales, Invoices, Purchase Orders and Received Inventory. Only users with Finance Admin role can changed, deleted or reversed transactions whether it is saved or posted. If you are part way through entering a transaction, you can erase it and start again. Sometimes, however, you may need to make changes or delete transactions that have already been recorded. The system provides few methods as resolutions to these situations

Saved or Un-posted Transactions

  1. Un-post transactions refer to documents or transactions that has been created and saved but not yet been posted. 
  2. To make changes on the document, click on Alter icon.
  3. Saved document is not a valid document and no Journals are created. 

Posted Transactions Posted transactions are transactions that have been recorded and Journals entry has been created. Posted transactions cannot be edited except for Dates, Items, prices, Department, Project, Sales Person and Remarks fields. No changes are allowed on vendor/customer and invoice number.


Corrections to Transactions

Manage trxn
  • Undo transactions will auto delete related financial Journals
  • Un-posted Invoices are editable. This feature can be used to correct mistakes without the need to void a financial transaction
Manage trxn 2
  1. Manage transactions feature only allows Finance Admin to roll back transactions in Sales and Purchases and Undo Payments in Receivables or Expenses.
  2. Move your mouse to Accounting >> click on Manage Transactions
  3. Select Category of the document you wish to roll-back; Purchase, Sales, Receivables & Expenses
  4. Select Transaction number 
  5. Click Get Transaction to retrieve transaction record
  6. Click view to view transaction details
  7. Click Un-post Transaction to reverse transaction status
  8. Click Undo Payments to reverse/void Receipt or Payment Voucher
  9. Click copy icon in Details column to make of a copy of transaction details. This feature is available for Receivables and Expenses transactions only
  10. The following table explain the function of button available on manage transactions page.
Undo payment
Note: Though the Journals have been deleted, audit trail will capture these corrective actions for audit purposes.

Transaction Control

This function allows Finance Admin to control transaction which has been done and only allows transactions within the 'Allowable Transaction Period' to be processed by the system. Any transactions outside of the allowable period will generate an error message.

To block unwanted transactions, move your mouse to Accounting >> Manage Transactions >> click on Transaction Control

Set the allowable period for data entry by entering the 'Date From' and 'Date To' fields and click on the 'Activate' checkbox

This feature can be turned ‘On’ and ‘Off’ by the Finance Administrator only 

This feature is recommended to be used to control data entry during a GST reporting period.

Audit Trail

Audit Trail is a built in governance to ensure all transactions, edits, updates and other changes are tracked by the system. 

Audit trail

Bulk Transactions

Make Bulk Payment

This module will create Payment Vouchers (multiple) for any Purchase Invoices with a Payment Amount.

To perform bulk payment, go to Accounting >> click on Create Bulk Payment

BulkPayment)1

Steps:

  1. Enter your Vendor
  2. Select the Date Range
  3. Click on Search button to continue
BulkPayment 2
BulkPayment 3

Payment Voucher will auto-generate by the system in Payment Voucher Listing.

To view, go to Purchases >> Click on View Payment Voucher

BulkPayment 5

Bulk Receive Payment

This module will create Receipts for any Sales Invoices with a Payment Amount (open status).

To perform receive bulk payment, go to Accounting >> click on Create Bulk Receive Payment

ReceivePayment 1

Steps:

  1. Enter your Customer
  2. Select the Date Range
  3. Click on Search button to continue
ReceivePayment 2
ReceivePayment 3

Receipts will auto-generate by the system in Receipt List.

To view, go to Sales >> Click on View Sales Receipt

ReceivePayment 5

Foreign Exchange Gain/Loss Declaration

This function allows you to declare your foreign exchange gain and loss for other currencies

To make the declaration, you will need to go to Accounting >> Others >> Foreign Exchange Gain/Loss Declaration

  1. Select the transactions date
  2. Select the Foreign Exchange Gain/Loss Account. You will need to create your own account as the system do not provide any default account for this purpose
  3. Enter your declaration date and select the tax code, if applicable
  4. Enter transactions remarks
  5. Click View
  6. Tick the transactions that you would like to declare
  7. Once you have selected the transactions, click process
  8. System will then generate general journal to record this declaration
Forex

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.