Need a quick hand please!
Raging Pineapples
Registered Posts: 110 Dedicated contributor 🦉
Would someone do me a little favour?
I don't have access to Sage Instant for another 3 weeks, but I need to try something out, so if someone could try this for me I'd really appreciate it.
On the journals screen, you have the following fields:
N/C, Name, Details, T/C, Debit, Credit
If you fill these in in EXCEL like-a-da-so:
1200,[blank],TRF In,T9,100,0
1200,[blank],TRF Out, T9,0,100
And copy the range and paste it into the Journals, does it automatically crosscast them into the correct locations?
I know some apps do this by default because when you copy a range in Excel, it's automatically converted on the clipboard to use tabs to separate cells horizontally, and returns to separate each row.
I'm preparing a payslip generator which then generates the double-entry journal for the transaction. It'd be a nice touch if the user could just copy and paste the journal, but I don't know if it'd actually work.
Would be really appreciated! I tried it on Sage's Test Drive system, but the Test Drive uses its own clipboard so you can't copy and paste from your PC into the Test Driven Sage.
Thanks,
Chris
I don't have access to Sage Instant for another 3 weeks, but I need to try something out, so if someone could try this for me I'd really appreciate it.
On the journals screen, you have the following fields:
N/C, Name, Details, T/C, Debit, Credit
If you fill these in in EXCEL like-a-da-so:
1200,[blank],TRF In,T9,100,0
1200,[blank],TRF Out, T9,0,100
And copy the range and paste it into the Journals, does it automatically crosscast them into the correct locations?
I know some apps do this by default because when you copy a range in Excel, it's automatically converted on the clipboard to use tabs to separate cells horizontally, and returns to separate each row.
I'm preparing a payslip generator which then generates the double-entry journal for the transaction. It'd be a nice touch if the user could just copy and paste the journal, but I don't know if it'd actually work.
Would be really appreciated! I tried it on Sage's Test Drive system, but the Test Drive uses its own clipboard so you can't copy and paste from your PC into the Test Driven Sage.
Thanks,
Chris
0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership