x Want to participate? Join the group to interact

Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Core Financial Modules Bank deposit question

Bank deposit question

Posted By Glenn77 over 8 years ago

I have a bank deposit ($1,000.00). Of that amount, $600 is a payment from a customer, while the $400 is reducing a current Liability (Due To XXXX).

How do I get this to show as only the $1,000 deposit in the bank general ledger? Up till now I have been doing separate entries for these types of things then having to reconcile these at the end of month when doing my bank rec.

0 jnelsonut over 8 years ago

Do a cash receipt for $1000.00 and apply $600.00 to the customer and for the $400.00, type in Cash or 00-Cash if you use divisions in AR and apply to the appropriate GL Account under Lines.

Joe
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Glenn77 over 8 years ago in reply to jnelsonut

Sorry I explained it a little incorrectly. Ideally this is what I want to do:
DR Bank $1,000
DR Due To XXX (this is a current liablity) $400
CR Accts Receivable $1,400
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jnelsonut over 8 years ago in reply to Glenn77

You can manipulate the Cash Receipt anyway you like in lines as long as the balance is $0.00 when you're finished. Just don't apply to a control GL Account such as Accounts Receivable, Accounts Payable, Cash.......

Joe
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TomTarget over 8 years ago in reply to jnelsonut

When you get to the -400 amount.

Type in CASH for the customer - fill in a name or description in the name field.
Amount received is -400.
Go to the lines tab. Make sure the line type is GL Account and enter the desired account and -400 for the amount.

Note that you won't be able to go to Accounts Payable module with it. (There is a way however to offset receivable and payable module accounts if set up properly.)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel