imis financial functions – where are they now?

iMIS Financial Functions –

Where Are They Now?

Association Technology Solutions

Laura Tidquist – Sr. iMIS Consultant

http://www.atsol.org/

About ATS

∗ Serving iMIS community since 1995

∗ Full-service Authorized iMIS Solutions Provider (AiSP)

∗ Application development to extend the functionality of iMIS

∗ 2015 and 2016 Authorized iMIS Solution Provider (AiSP) of the Year

Hosted by

Moderator:

Richard BanksSales ManagerAssociation Technology Solutions, LLCDirect: (571) 213-4785Email: rbanks@atsol.org

Presenter:

Laura TidquistSenior iMIS ConsultantAssociation Technology Solutions, LLCDirect: (720) 945-7255Email: ltidquist@atsol.org

Using GoToWebinar

∗ Attendees are muted to reduce background noise

∗ Remember to ask questions via the Questions

panel

∗ Questions will be answered during Q&A after presentation is complete

Setup options in the staff site20.2.65.9830 – Patch S

∗ General – replaces AR/Cash>>Set up module screen

Settings>>Finance

Setup options in the staff site

∗ Financial entities – includes Default Accounts

∗ Replaces File>>System Setup >>Organization Names

∗ Replaces AR/Cash>>Set up module>>Default Accounts

Settings>>Finance

http://www.atsol.org/

∗ Due to/due from – replaces AR/Cash>>Set up tables>>DueTo/DueFrom

Setup options in the staff site

Settings>>Finance

http://www.atsol.org/

∗ Tax categories – this is for VAT taxation to apply tax at product category level

∗ Replaces AR/Cash>Set up tables>>Tax categories

∗ Tax codes – replaces AR/Cash>>Set up tables>>Tax codes

Setup options in the staff site

Settings>>Finance

http://www.atsol.org/

∗ Cash accounts – replaces AR/Cash>>Set up tables>>Cash accounts

∗ Payment method sets – replaces AR/Cash>>Set up tables>>Payment method sets

Setup options in the staff site

Settings>>Finance

http://www.atsol.org/

∗ Gateway accounts – Replaces AR/Cash>>Set up module>>Credit Card Auth. Desktop option not available anymore.

Setup options in the staff site

Settings>>Finance

Setup options in the staff site

Settings>>Finance∗ Terms – Replaces AR/Cash>>Set up tables>>Terms

∗ Aging – Replaces AR/Cash>>Set up module>>Aging

http://www.atsol.org/

∗ Automatic payments –Settings for automatic payments∗ Recurring donations∗ Auto-renew membership

∗ Automatic payment gateways – Processor(s) used for automatic payments.

∗ AutoPay status –Replaces AR/Cash>>Automatic payments

Setup options in the staff siteSettings>>Finance

http://www.atsol.org/

∗ Invoices - query display

∗ All or open invoices

∗ Invoice number

∗ Invoice date range

∗ Bill to name contains

∗ Type – gift, pledge, regular

∗ Source system – aka module

Staff Site functionality

Finance

http://www.atsol.org/

∗ View batches

∗ Query options – open, ready, search

∗ Batch is displayed with drill down to detail

Staff Site functionality

Finance

http://www.atsol.org/

∗ View batches

∗ Print Summary

∗ Print Details

∗ Print Summary by Payment Method

∗ Print Details by Payment Method

Staff Site functionality

Finance

http://www.atsol.org/

∗ Advanced Accounting Console Do Not Use

Staff Site functionality

Finance

http://www.atsol.org/

∗ Account Statement – prompt by ID – or run for all open balances

∗ AR Cash Daily Distribution Summaries – date prompt

∗ AR Cash Distribution Detail – date prompt

∗ AR Cash Transactions – date prompt

∗ Credit Card Post Authorization Audit – date prompt

∗ Credit Card Post Authorization – date prompt – has more detail than CC Post Authorization Audit report

∗ Deferred Income Analysis Spread

∗ Deferred Income Audit Trail – Effective date prompt

Reports

Continuum>>Accounting reports

http://www.atsol.org/

∗ Deferred Income Detail

∗ Deferred Income Matrix Summary

∗ NOTE: I found that some of the deferred income reports weren’t the same when running from the desktop vs. staff site and it looks like some of the totals in the Crystal reports are wrong.

∗ General Ledger Journal Daily Summary

∗ General Ledger Journal Detail

∗ General Ledger Journal Monthly Summary

∗ PayPal Reconciliation – this is for PayPal Express only.

Reports

Continuum>>Accounting reports

http://www.atsol.org/

∗ Batches

∗ Post batches

∗ Reopen batches

What do I still have to do in the desktop?

http://www.atsol.org/

∗ AR/Cash

∗ Credit memos (available in 20.3 - cloud)

∗ Debit memos (available in 20.3 - cloud)

∗ Import transactions (payment importer)

What do I still have to do in the desktop?

http://www.atsol.org/

∗ Month-end procedures

∗ Create GL Journal (GL Interface)

∗ Credit Invoices (refunds)

∗ Credit/Debit Write-offs

∗ Deferred Income Records (matrix)

∗ Reports

∗ Trial Balance

∗ Batch Distribution Summary

What do I still have to do in the desktop?

http://www.atsol.org/

20.3 Cloud Features

Staff are allowed to enter pre-payments and overpayments.

http://www.atsol.org/

20.3 Cloud Features

Staff can select desired batch or create a new one.

http://www.atsol.org/

Batches can be posted or set to ready

http://www.atsol.org/

Record Reversals

http://www.atsol.org/

Pre-payments

∗ Contact will automatically receive an email for this transaction.

http://www.atsol.org/

Transfers (*Tab)

http://www.atsol.org/

∗ Can be run for all (same prompts as desktop) or can be run for a single ID.

Trial Balance!

http://www.atsol.org/

1. Open AR – oldest first

2. Registration

3. Dues∗ New subscription items must be paid in full

∗ Renewals can be paid partially

4. Orders

5. Donations must be paid in full

6. Pre-pays send email to contact

Payment hierarchy – mixed cart

http://www.atsol.org/

∗ All functionality will be available in the 20.4 cloud version of the staff site.∗ Batch selection at payment in staff site

∗ Apply credits (*Tab)

∗ Post batches

∗ Adjust invoices

∗ Write-off

∗ Add/Remove items

∗ Adjust prices

∗ GL Export

iMIS Cloud 20.4

http://www.atsol.org/

∗ Classes

∗ Essentials of iMIS Cloud Finance

∗ iMIS Cloud Finance: Payment Processing

∗ iMIS Cloud Finance: Accounting Adjustments

∗ iMIS Cloud Finance: Closing Processes

∗ help.imis.com

∗ https://help.imis.com/imis2017/Features/Finance/Finance.htm

∗ https://help.imis.com/imis2017/Features/Settings/Finance.htm

ASI Resources

http://www.atsol.org/

For more information or to engage ATS contactinfo@atsol.org

Laura Tidquist Richard Banks

ltidquist@atsol.org rbanks@atsol.org

Thank you!

Questions?

http://www.atsol.org/