Cash Based Accounting Setup
Smartwebs Accounting doesn't have a setting for clients to declare "Cash" vs "Accrual" basis, because it records all system generated Journal Entries (Charges, Invoices, etc.) as Accrual basis entries first & also as Cash basis entries in addition to the Accrual entries whenever Cash is affected (Deposits, Refunds, AP Payments, Security Deposits, Forfeits, etc.).
Report Configurations
- Income Statement Detail Report
- Create a custom report
- Navigate to Accounting > Reports > Management Reports
- Open the Income Statement Details Report
- Select the gear icon in the upper-right corner
- Select the blue "Duplicate" button.
- In the Name section; Change the report name to "Income Statement Detail Report (Cash Basis)" or something similar
- Paste the same name in the Title and Description fields
- Select the blue "Save" button
- Select the template icon in the upper-right corner
- Add all applicable associations In the Associations dropdown menu' or leave the default of All associations.
- Select the blue "Save" button
- Close the Configuration screen
- Under More Options:
- Change the "Balance Based On" Section to "Cash" for the Revenue and Expense fields
- Options:
- From the Option dropdown, select "save".
- Select "Continue" to confirm
- Close the report
- Your new report will have a "New" and a "Custom" tag added to it
- From the Option dropdown, select "save".
- Create a custom report
- Financial Report Packets
- Create Cash Basis Financial Report Packets
- Navigate to Accounting > Reports > Report Packets
- To create a new report packet see FINANCIAL REPORTING SET UP and add the newly created Income Statement Detail Report (Cash Basis)
- To copy from an existing report packet:
- Open a current Financial Report Packet
- Under the "Options" menu; select "Copy"
- Close the report packet
- Open the new report packet (Your new report packet will have "- Copy" at the end)
- In the Name section; Change the name to "Monthly Financial Packet (Cash Basis)" or something similar
- In the Associations Section:
- Select the orange pencil icon
- Check the box next to each Cash Basis Accounting association
- Select the blue "Save" button
- In the Reports section:
- Select the orange pencil icon
- Unselect the checkbox next to the existing Income Statement Detail Report and check the box next to the newly created Cash Basis one
- Select the blue "Save" button
- Exit the screen
- Create Cash Basis Financial Report Packets
Beginning General Ledger Balances
Adjusting/Manual Journal Entries can be entered as EITHER Accrual OR Cash (defined by the User on creation of the JE). Since there is not enough information in a manual JE, the system doesn't know how to create the proper Cash-basis JE when the User enters the Accrual version, so the User is expected to create one Accrual JE and one separate Cash JE.
So on "Add Journal Entry":
- If "Is Cash" is FALSE --> Accrual JE
- If "Is Cash" is TRUE --> Cash JE
Also referred to as Opening/Starting Balance
Enter these General Ledger Balances after entering homeowner balances to better assist you with creating your "Clearing Journal Entry".
To enter the beginning balances for your association, you will need the ending balance of each General Ledger account in your prior software. Report names can vary between accounting platforms, but it is typical to have a General Ledger or Trial Balance report available. You will create one Journal Entry using the values from your report.
- Journal Entry
- Navigate to Accounting > GL > Journal Entries
- Select the '+Add Journal Entry' button
- Date - the last day of the month in your prior software
- Memo - Example: Balance Forward as of 12.31.2023
- GL Code/GL Account - Enter the code or name for a GL with an ending balance.
- Cost Center - Select the Cost Center for the specified GL if different than the designated default Cost Center
- Debits/Credits - Enter the balance in the appropriate side of the entry. See the Account Types section for additional information and suggestions
- Continue adding entries for each GL with an ending balance.
- If there is a variance (in red) at the end of your entry, that amount is added to your Capital, Equity or Retained Earnings GL. This amount is your Equity/Net Income (Loss) through the "as of" date.
- Crediting for Net Income or Debiting for Net (Loss)
- Select the 'Save" button to post
- Repeat this same Journal Entry, but mark the "Is Cash" box for the Cash Basis Journal Entry
Note: Once this “Beginning Balance” entry is posted, Balance Sheet/Income Statement(s) should have identical Balances in both Prior Financials & Smartwebs Financials.