1 of 75

Welcome to CTAS�Investments

With David Frame

MAT Trainer

Small City and Town Accounting System

1

2 of 75

AGENDA

Short Course

March 16, 2022

2

Other Materials

Create an Investment

Add Interest

Withdrawals

Reports

3 of 75

Other Materials

3

CTAS Users Manual, Chapter 16, osa.state.mn.us

Statement of Position letters at OSA

(Office of State Auditor)

4 of 75

Other Materials

4

osa.state.mn.us

5 of 75

Other Materials

5

6 of 75

Other Materials

6

7 of 75

Other Materials

7

8 of 75

Other Materials

8

CTAS Users Manual, Chapter 16, osa.state.mn.us

Statement of Position letters at OSA

(Office of State Auditor)

9 of 75

Other Materials

9

10 of 75

Statement of Position, OSA

10

11 of 75

Statement of Position, OSA

  • Custodial Credit Risk
  • Legal Restrictions on Public Investing
  • Qualified Safe Keepers
  • Depositories and Collateral
  • FDIC Rules for Government Deposits

11

12 of 75

Collateral

12

13 of 75

Investments

Small City and Town Accounting System

13

14 of 75

Create an Investment

14

15 of 75

Ceate an Investment

15

16 of 75

Create an Investment

16

17 of 75

Create an Investment

Small City and Town Accounting System

17

18 of 75

Create an Investment

Small City and Town Accounting System

18

19 of 75

Create an Investment

Small City and Town Accounting System

19

CTAS assumes the money going into the investment is coming out of checking!

20 of 75

Creating an Investment…Disbursement

Small City and Town Accounting System

20

IAD:

Investment Automatic Disbursement

21 of 75

Creating an Investment…Disbursement

Small City and Town Accounting System

21

22 of 75

Creating an Investment…Disbursement

Small City and Town Accounting System

22

23 of 75

Creating an Investment…Disbursement

Small City and Town Accounting System

23

24 of 75

Creating an Investment…Disbursement

24

25 of 75

Creating an Investment…Disbursement

25

26 of 75

Creating an Investment…Disbursement

26

27 of 75

Creating an Investment

27

Checking to Investment at same bank

New money received

Receipt the new money…

then create investment

28 of 75

Creating an Investment

28

Checking to Investment at same bank

New money received

Money in checking to savings at Bank 2

29 of 75

Creating an Investment

29

Money in checking to savings at Bank 2

Create Claim>Disbursement, check goes to Bank 2

Create an Investment in CTAS

Delete IAD

30 of 75

Creating an Investment

30

31 of 75

Creating an Investment

31

32 of 75

Creating an Investment

32

33 of 75

Creating an Investment

33

34 of 75

Creating an Investment

34

35 of 75

Creating an Investment

35

Checking to Investment at same bank

New money received

Money in checking to savings at Bank 2

New Money to savings at Bank 2

Receipt new money

Claim/Disbursement

Add/Create Investment

Delete IAD

36 of 75

Creating an Investment

36

Checking to Investment at same bank

New money received

Money in checking to savings at Bank 2

New Money to savings at Bank 2

Record existing Savings/CD

Create Investment

Delete IAD

37 of 75

Interest

37

Receive interest on an investment

-added to the investment.

38 of 75

Interest

38

39 of 75

Interest

39

40 of 75

Interest

40

41 of 75

Interest

41

42 of 75

Interest

42

43 of 75

Interest

43

Receive interest on an investment

Paid to you, not added to investment by bank

Receipt money into checking

44 of 75

Interest

44

Accrued Interest

45 of 75

Interest

45

46 of 75

Withdrawal

46

47 of 75

Withdrawal

47

48 of 75

Withdrawal

48

49 of 75

Withdrawal

49

50 of 75

Withdrawal

50

51 of 75

Withdrawal

51

52 of 75

Withdrawal

52

53 of 75

Withdrawal

53

54 of 75

Withdrawal

54

From savings to checking at same bank

From savings at bank 2 to checking at bank 1

Receipt money

Create Withdrawal in Investments

Delete IAW

55 of 75

Withdrawal

55

From savings to checking at same bank

From savings at bank 2 to checking at bank 1

56 of 75

Withdrawal

56

From savings to checking at same bank

From savings at bank 2 to checking at bank 1

Other things to think about…

There may interest in the pay out that you have not receipted,

There may be a penalty for early withdrawal,

57 of 75

Withdrawal

57

58 of 75

Withdrawal

58

59 of 75

Withdrawal

59

60 of 75

Withdrawal

60

61 of 75

Withdrawal

61

62 of 75

Withdrawal

62

63 of 75

Reports

63

64 of 75

Reports

64

65 of 75

Reports

65

66 of 75

Reports

66

67 of 75

Special Fund Numbers and Account Numbers

67

Townships will borrow/bond to acquire funds to do a significant project like a road rebuild.

This money is often put into an ‘investment’ until it is needed to pay for the construction costs.

A separate fund and fund number is recommended for the proceeds of the bond.

68 of 75

Special Fund Numbers

68

69 of 75

Special Fund Numbers and Account Numbers

69

70 of 75

Special Fund Numbers and Account Numbers

70

Receive money from bond sale and create an Investment

Receipt the money into CTAS,

Create an Investment in CTAS,

Make a deposit into the investment with the new Fund number.

Besure, to handle the IAD entry.

71 of 75

Questions?

71

72 of 75

Contact info:�dframe@mntownships.org 763.488.4050�or �MAT Office 763.497.2330

David Frame

MAT Trainer

Small City and Town Accounting System

72

73 of 75

Thank You� for taking the time to attend

CTAS - Small City and Town Accounting System

73

74 of 75

Small City and Town Accounting System

74

75 of 75

Select Claims to Print

75